Reading files on the server

2003-11-13 Thread Gunnar Berglund
Hi all,   I have a problem I hope you could help with.   I have a job running on db server side as a cron and it creates information (log files). What methods I have if I want to read those log files with some pl/sql procedure etc (I mean from inside the db), are there any others than utl_file (whi

Re: Reading files on the server

2003-11-14 Thread zhu chao

Re: Reading files on the server

2003-11-14 Thread Pete Finnigan
Hi Gunnar, You can use utl_file, it doesn't read from the same directory, you specify utl_file_dir locations pre 9iR2 and directory objects 9iR2 onwards to where you want it to read from and then you open and read the fil3es you wish. You could also use external procedures and use C, you could use

RE: Reading files on the server

2003-11-14 Thread Bellow, Bambi
$NForsomething}'` def somevar2=$SOMETHINGFROMEARLIERINTHISPGM select &somevar*&somevar2 from dual; exit EOF   HTH, Bambi. -Original Message-From: Gunnar Berglund [mailto:[EMAIL PROTECTED]Sent: Thursday, November 13, 2003 10:14 PMTo: Multiple recipients of list ORACLE-LSu

RE: Reading files on the server

2003-11-14 Thread Jamadagni, Rajendra
facts, having an opinion is an art ! -Original Message-From: Bellow, Bambi [mailto:[EMAIL PROTECTED]Sent: Friday, November 14, 2003 11:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Reading files on the server There are really two answers to this and it depends