Forms :: File Transfer From Server Directory To Client?

Oct 3, 2013

I write a file on database server by following

CREATE OR REPLACE DIRECTORY TEST_DIR AS 'c: emp'
GRANT READ, WRITE ON DIRECTORY TEST_DIR TO myuser
SQL> select * from all_directories;

OWNER DIRECTORY_NAME
------------------------------ ---------------------
DIRECTORY_PATH
----------------------------------------------------
SYS TEST_DIR
c: emp
SYS PUBLIC_DIR
E:PUBLIC_dir

and then

PROCEDURE run_query(p_sql IN VARCHAR2
,p_dir IN VARCHAR2
,p_header_file IN VARCHAR2
,p_data_file IN VARCHAR2 := NULL) IS

[code]...

but I get error wut_118.

View 1 Replies


ADVERTISEMENT

Forms :: Webutil File Transfer Directory Listing

May 25, 2010

Is there anyway to get a listing of the files in a specified directory on an ftp server using webutil?

View 2 Replies View Related

Forms :: File Transfer Through Pl/sql Programming?

Jun 15, 2011

I am facing a issue with one of my programming application. We need to transfer a file through pl/sql programming from a unix server to another destination(target) server.

How can we do it through pl/sql programming. I learnt that oracle streams can be used for this.

I do not know what all code is required for this. send me the code for a sample text file.

I also want to encrypt with a password and zip the file

View 3 Replies View Related

How To Transfer Output File From One Server To Another Using Stored Procedure

Apr 9, 2012

We are running a store procedure by calling it from shell script.The shell script is running in Server1 and the stored procedure is running in server2(which is the data base server.).

Functionality of the stored procedure:Generating a tab delimited file and place in a directory.

Requirement: The requirement is that the store should be modified in such a way that it should drop the output file to Server1 itself(The server from where it is getting called).

Attaching the store procedure for reference. mIn the store procedure,we have a variable "lv_file_dir" which currently refers to the directory location in Databse server(Server 2) We have to change this SP such that it drops the generated file in Server1 itself(From where the shell script is running).

Attached File(s)
Procedure.txt ( 3.28K )
Number of downloads: 4

View 2 Replies View Related

Performance Tuning :: Command To Transfer File From Local To Remote Server

Apr 21, 2011

I ran a scp command to transfer a file from local server to a remote server. when I am trying to kill the process, its giving an error.

ksh: kill: 19258: No such process

If I do a ps -ef | grep scp its showing the process running, but if i try to kill it, its showing me error.

View 7 Replies View Related

Forms :: Download File From Client To Server

Feb 28, 2010

When I try to download file from client to server a found the following error./oas/product/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar.

View 8 Replies View Related

Forms :: Upload A File From The Client To App Server In Runtime?

Jul 16, 2013

I need to upload a file from the client to app server in runtime.

Opening some kind of explorer to choose the file then upload the file and safe the path in a database column.

View 3 Replies View Related

Forms :: How To Get File Directory Path Dynamically In The Report

Sep 6, 2013

I want to get file directory path dynamically with out using directory in database or not hard code like below

the purpose is i need to check image in the path directory if not found i unable to generate report, is there any possible to get dynamically

function CF_URLFormula return Char is
v_handle utl_file.file_type;
v_file_dir VARCHAR2(60) := '/u002/app/applmgr/temp/';
begin
v_handle := utl_file.fopen(v_file_dir, :photo_name, 'R');
utl_file.fclose(v_handle);
RETURN v_file_dir||:photo_name;
exception
when others then
srw.message(100,SQLERRM);
return null;
end;

View 1 Replies View Related

Forms :: Generate File From Database Into Server And Copy It To Client Machine

Feb 2, 2012

I have a forms that generate a file from database into database server and copy it to client machine by the follow process:

IF webutil_file_transfer.Is_AS_readable(V_server_way || V_file_name) THEN

l_success := webutil_file_transfer.AS_to_Client
(clientFile => :V_screen_way

[code]...

But is showing the erro ora-105100 in one client machine

View 9 Replies View Related

Forms :: Copy Image Or Text File From Source Directory To Destination

Oct 31, 2011

how do i copy an image or a text file from ex: directory c to directory d

View 5 Replies View Related

Client Tools :: How To Transfer Data From Sql To Oracle

Jan 18, 2011

want to transfer data from sql to oracle having same structure in both database.

View 3 Replies View Related

Server Utilities :: How To Access Local File Residing At Client From DB Server

Nov 23, 2011

I have a requirement to read flat text file(around 15000 lines) residing at a client location from DB server and write into a table in One cell.

I tried UTL_FILE and DBMS_LOB but, i am not able to access client location to read the file as it reads path from Oracle Directory.

eg.
my client path is 198.168.1.1 and my DB server is in unix say 192.168.1.10.
file location is: \192.168.1.1shareabc.txt
So I created One Oracle directory as MY_DIR having DIRECTORY_PATH as '\192.168.1.1share'.
But both UTL_FILE and DBMS_LOB is not able to access the file.

Error Message:
-------------
Unable to process CLOB -22288 ~ ORA-22288: file or LOB operation FILEOPEN
failed
No such file or directory

Few Details for reference:
-------------------------
File Location: \192.168.1.1shareabc.txt
Unix DB Server location: 192.168.1.10
Table : Test (filename varchar2(30), Content CLOB)
Oracle Dir: MYDIR
Directory_Path: \192.168.1.1share

View 7 Replies View Related

Data Guard :: Unable To Transfer Archivelog Wrong Pass File

Aug 2, 2010

I am creating physical standby database through Rman duplicate command from 2 node rac cluster. rman do all its work. now am try to start the mrp process on physical standby database. I am getting following errors

------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
ORA-16191: Primary log shipping client not logged on standby
------------------------------------------------------------

I copied the same pass file from primary to standby and many times verify the same but i got the same error.

View 4 Replies View Related

SQL & PL/SQL :: Read All Files In Directory On Client's Machine

May 30, 2012

I want to read all the files present in a directory of client's machine.

However I have achieved this by creating java class in database but the problem is it accesses the directory of machine on which database is installed not the client's machine.

I have oracle client and I tried to access local directory of client's machine to read all the files in that directory but it didn't work.

However, I achieved this by creating one java class for ex. test.class and I run it locally through command prompt but I want to achieve it using Pl-sql.

View 8 Replies View Related

Client Tools :: Create Directory In UNIX

Jun 28, 2013

What is the script for creating SQL directory in UNIX.

Create or replace directory CONFIG as 'c:Config'

View 13 Replies View Related

SQL & PL/SQL :: How To Get The File Name From Directory

Dec 12, 2012

How to get the file name from directory without Java. Is there any way to do it in Pl/Sql.

View 13 Replies View Related

Client Tools :: SP2-0750 / Set ORACLE_HOME To Oracle Software Directory

Jan 29, 2010

bash: sqlplus: command not found
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

i install oracle 10gR and the process was successful i could do everything. the problem started when i install Zend Core for oracle, the install of zend was successful but i now can't start sqlplus.

View 18 Replies View Related

Accessing File From Directory?

Oct 7, 2009

have a log file in unix server under(/usr/home/oraj/log/abc.log) I am trying to access from oracle stored procedure as fallows

src_clob BFILE := BFILENAME('/usr/home/oraj/log', 'abc.log');

Exception:
ERROR at line 1:
ORA-22285: non-existent directory or file for FILEOPEN operation
ORA-06512: at "SYS.DBMS_LOB", line 716
ORA-06512: at "usr.LOAD_CLOB_FROM_XML_FILE", line 39
ORA-06512: at line 1

I dont want to create directory as such ('/usr/home/oraj/log') as it is already exists and all log files sits there.

CREATE OR REPLACE PROCEDURE Load_CLOB_From_XML_File
IS
dest_clob CLOB;
src_clob BFILE := BFILENAME('/usr/home/oraj/log/', 'abc.log');
dst_offset number := 1 ;
src_offset number := 1 ;

[code]...

View 1 Replies View Related

SQL & PL/SQL :: Generates CSV File In Directory

Feb 17, 2012

This generates a CSV file in an directory. When it runs for the 1st time it take SYSDATE -7 data. After the 1st run it appends the data since the last run. Now my problem is the appending happens at the bottom of the file and every time the header appears. I want the header only the first time and the new data should keep appending at the top so that i get the latest data always at the top.

View 18 Replies View Related

There Is No File Audit In Adump Directory

Jan 6, 2013

I have an issue when I enable auditing feature in oracle,I use 'DB' to store the audit from user in oracle, my command is

SQL>alter system set audit_trail=db scope=spfile;
SQL>shutdown immediate;
SQL>startup;

in show parameter audit, I see that the audit_trail already changed to DB after I create a user and enable audit for this user, I can see in the audit table dba_audit_trail for insert, update, delete,etc but If I am not wrong, if I using DB to setting the audit parameter then I will get audit file both in oracle table and in adump oracle folder installation, but in my case I cannot find any file in adump directory.

my operating system is windows7 and I use oracle database 10g express edition

View 8 Replies View Related

Transfer Data From Sql Server To EBS?

Jun 28, 2012

I need to transfer data from Mirco Soft SQL server to Oracle data base (EBS).

View 3 Replies View Related

Server Administration :: Transfer All Users From Server A To B?

Feb 23, 2012

i want to transfer all users from server A to server B how can i do that along with their rights and password?

View 2 Replies View Related

Enterprise Manager :: Setup - No Such File Or Directory

Jun 17, 2010

This is the error message iam getting when trying to open EM... Im new to DBA and also to this DB....

[sandeep@Linux4 ~]$ emctl start dbconsole
TZ set to US/Eastern

Unable to locate file /home/sandeep/oracle/product/10.2.0/db_1/Linux4.localdomain.com_orcl/sysman/config/emd.properties : No such file or directory

View 16 Replies View Related

PL/SQL :: Directory List - How To Read File Names

Jun 7, 2013

i have one directory in this directory contains 100 file these files are related to table structured creation with dependence

so how to read file names from directory and executed in scheme with logs also

procedure or script

View 5 Replies View Related

Listener File Rapidly Increasing In Diag Directory Of 11g

Jul 6, 2012

I noticed that listener file in diag/trace is rapidly increasing. I am using 11g Rel 1 on window 2008 server Its 1 GB in couple of days. Is there any way if I can turn it off ?

View 5 Replies View Related

Forms :: To Excel Data Transfer

Apr 8, 2010

I found another way to transfer the data from forms to excel apart from doing it through ole2 or client. So thought of sharing it with all...

Here it goes:-

declare
ifile client_text_io.file_type;
temp varchar2(1000);
Cursor c1 is select ename, job from emp;

[Code]....

Attach webutil to form and just paste the code on a button and log on to scott. The excel file will be created in c: drive with name test.

View 5 Replies View Related

Open Excel File From Oracle Directory On Local Machine

May 31, 2013

I have an application where I generate a excel using data in a table and write excel file in oracle directory.Now my requirement is to open that file from local machine .How can i achieve it.I am using Apex 4.2,Oracle 10g .

View 1 Replies View Related

Forms :: Transfer Data From Oracle 9i To Serial Port?

Feb 14, 2012

I want to transfer data from Oracle form 9i to serial port.

Serial port is connected to electric board to show.

View 2 Replies View Related

Forms :: 11g - From RFC 2068 Hypertext Transfer Protocol / 404 Not Found

Sep 4, 2013

While Running Forms 11g i get the following message in web browser,.how to deploy forms 11g in weblogic

From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.4.5 404 Not Found
aLSO the error file is attached with this.

View 2 Replies View Related

Application Express :: Automatic Save File From Apex To User Local Directory

Jun 13, 2012

how can save pdf file from apex to user local directory on button click?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved