945570
"Mohammad Rafiq" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/03/2002 02:11 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Utl_file and OPENVMS
I am reproduc
ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Utl_file and OPENVMS
I am reproducing below an email from John Kanagaraj for your info..
It might help you further...
Regards
Rafiq
Date: Thu, 15 Aug 2002 00:08:35 -0800
Kathy,
This is probably not documented, but
10/01/2002 11:25 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject:RE: Utl_file and OPENVMS
i believe its
utl_file_dir=dir1,dir2,dir3,...
in your example, dir 3 would be the only
002 11:25 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject:RE: Utl_file and OPENVMS
i believe its
utl_file_dir=dir1,dir2,dir3,...
in your example, dir 3 would be the only valid dir.
hth
ut it.
Jared
"Gene Sais" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/01/2002 11:25 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject:RE: Utl_file and OPENVMS
i
.
Jared
"Gene Sais" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/01/2002 11:25 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject:RE: Utl_file and OPENVMS
The single line with comma delimited entries may also work, though I'm
not sure about it.
Jared
"Gene Sais" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/01/2002 11:25 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMA
ma delimited entries may also work, though I'm
not sure about it.
Jared
"Gene Sais" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/01/2002 11:25 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
IL PROTECTED]
10/01/2002 11:25 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Utl_file and OPENVMS
i believe its
utl_file_dir=dir1,dir2,dir3,...
in your example, dir 3 would be the only v
ultiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Utl_file and OPENVMS
i believe its
utl_file_dir=dir1,dir2,dir3,...
in your example, dir 3 would be the only valid dir.
hth,
gene
>>> [EMAIL PROTECTED] 10/01/02 12:53PM >
PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/01/2002 11:25 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Utl_file and OPENVMS
i believe its
utl_file_dir=dir1,dir2,dir3,...
in your exampl
0/01/2002 11:25 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Utl_file and OPENVMS
i believe its
utl_file_dir=dir1,dir2,dir3,...
in your example, dir 3 would be the only valid dir.
hth,
gene
out it.
Jared
"Gene Sais" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/01/2002 11:25 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Utl_file and OPENVMS
i believe its
Thanks to all of you for the assistance.
I have the package working by coding the directory into the
utl_file.fopen command and the files are being created okay. I got the
batch procedure to work with the SQLLDR command( I did not know you had
to set noon and each line starts with a $). It works
i believe its
utl_file_dir=dir1,dir2,dir3,...
in your example, dir 3 would be the only valid dir.
hth,
gene
>>> [EMAIL PROTECTED] 10/01/02 12:53PM >>>
Make sure you have the directory name entry covered in INIT.ORA
e.g.
utl_file_dir = D:\directory name1
utl_file_dir = D:\directory name2
ut
Make sure you have the directory name entry covered in INIT.ORA
e.g.
utl_file_dir = D:\directory name1
utl_file_dir = D:\directory name2
utl_file_dir = D:\directory name3
You need one entry per directory that you want to write to using UTL_FILE
Package
Hope this helps
Regards
Shiva
the vms user oracle needs rights to the directory.
>>> [EMAIL PROTECTED] 09/30/02 10:53AM >>>
List,
I have a package that creates files on the server. The directory
location and file name are obtained from tables in oracle. The procedure
works as designed on Novell 7.3.4 and no changes were nee
Quad/Tech International, Sussex, WI USA
> -Original Message-
> From: Ron Rogers [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 30, 2002 9:53 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Utl_file and OPENVMS
>
>
> List,
> I have a package
List,
I have a package that creates files on the server. The directory
location and file name are obtained from tables in oracle. The procedure
works as designed on Novell 7.3.4 and no changes were needed when the
database way loaded on Linux Oracle 8.1.7. I am trying to move the
database from t
19 matches
Mail list logo