FW: utl_file example

2001-11-13 Thread Szecsy Tamas
://www.itsystems.lv/gints/ Szecsy Tamas tszecsy@GEOME To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] TRIA.hu cc: Sent by: Subject: RE: utl_file example

utl_file example

2001-11-12 Thread Szecsy Tamas
Hi, Sorry for the previous post with a wrong subject in it. Could somebody help me out with a very short utl_file example for Windows NT? I would like write error data into a simple text file, but I get exceptions. TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http

RE: utl_file example

2001-11-12 Thread Nirmal Kumar Muthu Kumaran
Title: RE: utl_file example Hi, Verify UTL_FILE_DIR init.ora parameter is defined properly. In FOPEN function specify, filepath and filename as separate. [EMAIL PROTECTED] ; 1 DECLARE 2 fid UTL_FILE.FILE_TYPE; 3 BEGIN 4 fid := UTL_FILE.FOPEN('c:\','test.log','w'); 5

RE: utl_file example

2001-11-12 Thread Szecsy Tamas
Title: RE: utl_file example Nirmal, do I have to set some OS acces rights? I get the following exception: ORA-06510: PL/SQL: unhandled user-defined exceptionORA-06512: at "SYS.UTL_FILE", line 98ORA-06512: at "SYS.UTL_FILE", line 157ORA-06512: at line 4 If I handle th

RE: utl_file example

2001-11-12 Thread G . Plivna
[EMAIL PROTECTED] TRIA.hu cc: Sent by: Subject: RE: utl_file example [EMAIL PROTECTED