OraFAQ Forum: Server Administration » URGENT Syntax question. File output

Home » RDBMS Server » Server Administration » URGENT Syntax question. File output

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

URGENT Syntax question. File output [message #370665]

Tue, 18 January 2000 04:42

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.

Report message to a moderator

Re: URGENT Syntax question. File output [message #370666 is a reply to message #370665]

Tue, 18 January 2000 10:43

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

Report message to a moderator

Re: URGENT Syntax question. File output [message #370667 is a reply to message #370665]

Tue, 18 January 2000 10:49

Mike
Messages: 417
Registered: September 1998

Senior Member

Have you looked at Oracle's built in package UTL_FILE ?

Report message to a moderator

Re: URGENT Syntax question. File output [message #370684 is a reply to message #370666]

Wed, 19 January 2000 04:18

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

Report message to a moderator

Re: URGENT Syntax question. File output [message #370688 is a reply to message #370684]

Wed, 19 January 2000 10:07

Mike
Messages: 417
Registered: September 1998

Senior Member

Did you set the UTL_FILE_DIR parameter in your init.ora file?

Report message to a moderator

Re: URGENT Syntax question. File output [message #370695 is a reply to message #370688]

Thu, 20 January 2000 02:36

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.

Report message to a moderator

Re: URGENT Syntax question. File output [message #370697 is a reply to message #370688]

Thu, 20 January 2000 11:35

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

Report message to a moderator

Re: URGENT Syntax question. File output [message #370717 is a reply to message #370688]

Sat, 22 January 2000 02:43

Laert
Messages: 20
Registered: January 2000

Junior Member

Thank You very much.
My problem solved.

Report message to a moderator

Previous Topic:	view problem
Next Topic:	PL SQL Tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 22:40:07 CST 2025