| 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
So, summa technologiae can be reduced to the simple advice:
"avoid NT if possible"?
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-----Original Message-----
Sent: Monday, June 30, 2003 11:05 AM
To: Multiple recipients of list ORACLE-L
Hi
SPOOL OUT will only write the SQL*plus output to the default printer on UNIX it is not implemented in SQL*plus for NT.
You cannot do what you are trying to do below. UTL_FILE can only read and write clear text files. I am not an expert on windows internals but lpt1 is a device / port so should be some sort of device driver so i guess it has a different file type. UTL_FILE probably does a check internally to test if the file being opened is a text file. your best bet is to use C to write an external procedure to do it, or perhaps pipe the output from a text file to the printer externally. i.e use utl_file to write to a file and have a batch job that runs every few minutes and spools the file to the printer?
hth
kind regards
Pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for
details.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Pete Finnigan
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).
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). Received on Mon Jun 30 2003 - 10:26:34 CDT
 |
 |