| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: printing out of Pl/SQL
Dick, it used to be so before 9.2. In 9.2 you have a parameter "location"
to utl_file.fopen, which is specified by using the "create directory"
command. I didn't see a version in his post so I assumed he's talking
about 9.2.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-----Original Message-----
Sent: Friday, June 27, 2003 2:15 PM
To: Multiple recipients of list ORACLE-L
Unless I'm totally mistaken '/dev' also has to be in the UTL_FILE_DIR init parameter.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
Sent: Friday, June 27, 2003 12:45 PM
To: Multiple recipients of list ORACLE-L
Interesting...
I should try it sometime.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-----Original Message-----
Gogala, Mladen
Sent: Friday, June 27, 2003 10:40 AM
To: Multiple recipients of list ORACLE-L
Oh, I missed the "PL/SQL" part. Here it is:
create or replace directory dev as '/dev';
grant read on dev to public;
fp:=utl_file.fopen('dev','lpt0','w',255);
I've never tried it personally, but this should work.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-----Original Message-----
Sent: Friday, June 27, 2003 11:15 AM
To: Multiple recipients of list ORACLE-L
The question was, how to do it from PL/SQL. I think, the only way is using external stored procedure.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-----Original Message-----
Gogala, Mladen
Sent: Friday, June 27, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L
dd if=<your file> of=/dev/lpt1
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-----Original Message-----
Sent: Friday, June 27, 2003 8:30 AM
To: Multiple recipients of list ORACLE-L
Hi gurus,
anyone knows of a possibility to directly send data to :LPT1 ?
I am in the need of printing online when something definite happens to
the
DB...........
TNX
> Frank <
Confidentiality Notes
This email and any files transmitted is intended only for the person or
entity to which it is addressed and may contain confidential and/or
privileged material. If you are not the authorised recipient, any use,
disclosure, copying, distribution or any action taken or omitted to be
taken
in reliance on it, is prohibited. If you received this in error, please
contact the sender and delete the material from any computer.
E-mail messages are not necessarily secure. Scheidt & Bachmann does not
accept responsibility for any changes made to this message after it was
sent.
Thank you for your cooperation!
Diese E-Mail und alle angehängten Dateien ist ausschließlich für die
Person
/ Personen bestimmt, an die diese adressiert ist und könnte vertrauliche
und
/ oder rechtlich geschützte Informationen enthalten. Sollten Sie nicht
der
für diese E-Mail bestimmte Adressat oder nicht zum Empfang berechtigt
sein,
ist Ihnen jeder Gebrauch, sowie jede Veröffentlichung, Vervielfältigung
oder
Weitergabe wie auch das Ergreifen oder Unterlassen von Maßnahmen im
Vertrauen auf erlangte Information untersagt. Sollten Sie diese E-Mail
irrtümlich erhalten haben, benachrichtigen Sie bitte den Absender und
löschen diese E-Mail von jedem Computer.
E-Mail-Mitteilungen sind nicht notwendigerweise sicher. Scheidt &
Bachmann
übernimmt keine Verantwortung für Veränderungen dieser Mitteilung, die
nach
dem Senden vorgenommen wurden.
Herzlichen Dank für Ihre Unterstützung!
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Foelz.Frank INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesReceived on Fri Jun 27 2003 - 13:50:57 CDT
---------------------------------------------------------------------
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: Gogala, Mladen 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: Igor Neyman 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: Gogala, Mladen 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: Igor Neyman 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: Goulet, Dick 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: Gogala, Mladen 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).
 |
 |