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).
