Re: help needed oracle utl_file access

2001-04-03 Thread Mark Wagner
:[EMAIL PROTECTED]] Sent: Tuesday, 3 April 2001 2:07 PM To: Mark Wagner; [EMAIL PROTECTED] Subject: RE: help needed oracle utl_file access Have you tried to run you PL/SQL in sqlplus to see if they work there. I would recommend printing them out than copy and paste to command prompt, since

help needed oracle utl_file access

2001-04-02 Thread Mark Wagner
al.fd := utl_file.fopen ('E:\Oracle\admin\LLPROD\udump', 'ora_2828.trc', 'r') ; DBD::Oracle::st execute failed: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "SYS.UTL_FILE", line 98 ORA-06512: at "SYS.UTL_FILE", line 157 ORA-06512: at line 2 (DBD ERROR: OCIStmtExecute) at ./documentor.pl line 189. END ; Thanks for any help you can give. Mark Wagner

Can I execute an OS command through oracle using dbi?

2001-03-22 Thread Mark Wagner
Is it possible to execute an os command through oracle using dbi? Mark -- Mark Wagner Phone - (510) 683-9681 Database Administrator [EMAIL PROTECTED

Re: Reading a trace file through Oracle? POSSIBLE??

2001-03-22 Thread Mark Wagner
file. Furthermore, it is executed as an 'oracle' owned process, so has the appropriate permissions. Let me know if you need any more help. Cheers, Steve -Original Message- From: Mark Wagner [mailto:[EMAIL PROTECTED]] Sent: Friday, 23 March 2001 4:21 AM To: [EMAIL PROTECTED