iten by Crocodile Descartes
> and Tim Bunce (ISBN:1-56592-699-4)
>
>
>
> On 2003.08.20 22:04, Richard Ji wrote:
> > You can also use Java Stored Procedures.
> >
> >
> > -Original Message-
> > From: Steve McClure [mailto:[EMAIL PROTECTED]
>
4 PM
To: Multiple recipients of list ORACLE-L
Cc:
Subject: RE: Text file from store procedure
You can spool output to the location of your choice in sqlplus. Forms
allows you to use a utl_file like procedure called 'text_io' I believe. In
6i the output is written to the client machine,
Hamid,
Hit www.hotsos.com and find Sparky. The trcfiled part of the
distribution is a well-documented Perl program that is capable of doing
utl_file's job between 100x and 1,000x faster than utl_file does it.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos
You can also use Java Stored Procedures.
-Original Message-
From: Steve McClure [mailto:[EMAIL PROTECTED]
Sent: Wed 8/20/2003 8:44 PM
To: Multiple recipients of list ORACLE-L
Cc:
Subject:RE: Text file from store procedure
You can spool output to the location of your
You can spool output to the location of your choice in sqlplus. Forms
allows you to use a utl_file like procedure called 'text_io' I believe. In
6i the output is written to the client machine, in 9i the results are
written to the app server.
Why don't you want to use utl_file? It is designed to
A somewhat messy way to do this, if you are on Unix, is a shell script
something like:
snip ---
#!/usr/bin/ksh
export ORACLE_SID=BUBBA
export ORALCE_HOME=/dir/dir/product/9.2.0
export PATH=$ORACLE_HOME/bin:${PATH:-/usr/bin:/usr/sbin:/whatever/else}
... anything else I f
It depends. What version of Oracle?
You can also create a file via Java Stored Procedure (requires at least
v8.0, possibly 8i?). If you're able to grant JAVA_SYSPRIV to the account
creating the file, you can also avoid the hassle of being restricted to
directories specified by the UTL_FILE_DIR i
Sure, write your own pro C++ to text converter. Otherwise nothing I
know about.
Allan
-Original Message-
Sent: Thursday, June 19, 2003 4:35 PM
To: Multiple recipients of list ORACLE-L
Hi,
Is there any other packages thru which we can generate text file except
UTL_FILE?
I want to gener