RE: Utl_file and OPENVMS

2002-10-03 Thread Mohammad Rafiq
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

RE: Utl_file and OPENVMS

2002-10-03 Thread Jared . Still
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

RE: Utl_file and OPENVMS

2002-10-03 Thread Mohammad Rafiq
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

RE: Utl_file and OPENVMS

2002-10-03 Thread Gene Sais
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

RE: Utl_file and OPENVMS

2002-10-03 Thread Mohammad Rafiq
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

RE: Utl_file and OPENVMS

2002-10-03 Thread Gene Sais
. 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

RE: Utl_file and OPENVMS

2002-10-03 Thread Mohammad Rafiq
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

RE: Utl_file and OPENVMS

2002-10-03 Thread Gene Sais
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]>

RE: Utl_file and OPENVMS

2002-10-03 Thread Mohammad Rafiq
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

RE: Utl_file and OPENVMS

2002-10-03 Thread Gene Sais
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 >

RE: Utl_file and OPENVMS

2002-10-02 Thread Vergara, Michael (TEM)
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

Re: Utl_file and OPENVMS

2002-10-02 Thread Babu Nagarajan
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

RE: Utl_file and OPENVMS

2002-10-02 Thread Jared . Still
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

RE: Utl_file and OPENVMS

2002-10-01 Thread Ron Rogers
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

RE: Utl_file and OPENVMS

2002-10-01 Thread Gene Sais
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

RE: Utl_file and OPENVMS

2002-10-01 Thread Baswannappa, Shiva
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

Re: Utl_file and OPENVMS

2002-10-01 Thread Gene Sais
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

RE: Utl_file and OPENVMS

2002-09-30 Thread Jesse, Rich
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

Utl_file and OPENVMS

2002-09-30 Thread Ron Rogers
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