If you are really brave, you can write stored procedures in the favorite language of Mr. Cary Milsap and the list owner, the only language that will take a syntax like this:
@list= reverse sort { -M $a <=> -M $b } @list;
The URL can be found at: http://www.smashing.org/extproc_perl
Not only it is possible to write to files, you can even format it into
multi-line fields, you can have page headers, repeating after every $=
lines. You can do marvelous things with strings and a whole lot of other
things. Standard for accessing the database is described in the O'Reilly
"cheetah" book named "Programming the Perl DBI" writen 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]
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 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 create and write text files from PL/SQL blocks.
-----Original Message----- Hamid Alavi Sent: Wednesday, August 20, 2003 4:19 PM To: Multiple recipients of list ORACLE-L
List of guru,
Is any body know how can I create a text file from store procedure without using utl_file , I want to create & write a text file from result of a select statement and write the result as a text file in a define directory. Thanks for your help.
Hamid Alavi
Office : 818-737-0526 Cell phone : 818-416-5095
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve McClure INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
-- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
