Home » RDBMS Server » Server Administration » URGENT Syntax question. File output
URGENT Syntax question. File output [message #370665] Tue, 18 January 2000 04:42 Go to next message
Laert
Messages: 20
Registered: January 2000
Junior Member
Hi!
Can someone help me?
How can I output some information more than 100K to OS File.

Thanx in advance.
Re: URGENT Syntax question. File output [message #370666 is a reply to message #370665] Tue, 18 January 2000 10:43 Go to previous messageGo to next message
Sreeni
Messages: 6
Registered: January 2000
Junior Member
Hi ,
You can use UTL FILE to send the output to
OS file .
Try with UTL FILE

Sreeni
Re: URGENT Syntax question. File output [message #370667 is a reply to message #370665] Tue, 18 January 2000 10:49 Go to previous messageGo to next message
Mike
Messages: 417
Registered: September 1998
Senior Member
Have you looked at Oracle's built in package UTL_FILE ?
Re: URGENT Syntax question. File output [message #370684 is a reply to message #370666] Wed, 19 January 2000 04:18 Go to previous messageGo to next message
Laert
Messages: 20
Registered: January 2000
Junior Member
I have tryed, but recived following error
ERROR at line 1:
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 11
Re: URGENT Syntax question. File output [message #370688 is a reply to message #370684] Wed, 19 January 2000 10:07 Go to previous messageGo to next message
Mike
Messages: 417
Registered: September 1998
Senior Member
Did you set the UTL_FILE_DIR parameter in your init.ora file?
Re: URGENT Syntax question. File output [message #370695 is a reply to message #370688] Thu, 20 January 2000 02:36 Go to previous messageGo to next message
Laert
Messages: 20
Registered: January 2000
Junior Member
I have not init.ora file and don't know, in which directory must be to create new one. In online docs no info about that.
I'm using Windows NT 4 Server and
Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production

Thank you.
Re: URGENT Syntax question. File output [message #370697 is a reply to message #370688] Thu, 20 January 2000 11:35 Go to previous messageGo to next message
Mike
Messages: 417
Registered: September 1998
Senior Member
When the database starts it reads a config file
called init(SID).ora where SID is the sytem identifier. The default is orcl so the file defaults to initorcl.ora One of the parameters you can place in this file is called UTL_FILE_DIR that tells oracle what directories it has permission to write to. You will have to consult with your dba to do this ofcourse
Re: URGENT Syntax question. File output [message #370717 is a reply to message #370688] Sat, 22 January 2000 02:43 Go to previous message
Laert
Messages: 20
Registered: January 2000
Junior Member
Thank You very much.
My problem solved.
Previous Topic: view problem
Next Topic: PL SQL Tables
Goto Forum:
  


Current Time: Thu Mar 28 13:04:48 CDT 2024