Hi Von If you do not want to have any opportunity to expose any external person or process to tamper the output file, then I think one way you could achieve it is by writing a report and run the report and print it directly to the printer. That would be just a bit of a work but it will meet the requirements.
THT Shiva -----Original Message----- Sent: Tuesday, July 01, 2003 2:35 AM To: Multiple recipients of list ORACLE-L Hi, >Von: Baswannappa, Shiva [mailto:[EMAIL PROTECTED] >Gesendet am: Montag, 30. Juni 2003 18:09 >1. Have the UTL_FILE write to a file in directory called >'printdir' (you can >name it whatever you like) ..... that is exactly the way it is running right now.... but our customer had to change it's mind due to some fiscal policies in his country. So I have to be more "online" with my printoutput..... Means, as soon, as the data reaches the database it has to be printed onto endless paper which is stamped by the finacial office. So "nobody" should be able to manipulate the data........... preventing tax fraud. > 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! ------------------------------------------------------------------------ --------------------------------------------- >-----Ursprüngliche Nachricht----- >Von: Baswannappa, Shiva [mailto:[EMAIL PROTECTED] >Gesendet am: Montag, 30. Juni 2003 18:09 >An: Multiple recipients of list ORACLE-L >Betreff: RE: printing out of Pl/SQL > >Hi > >I came across similar situation few months ago. You could do >following in NT >environment. > >1. Have the UTL_FILE write to a file in directory called >'printdir' (you can >name it whatever you like) >2. Write a NT Shell script to check for any file in >'printdir'. if there is >one, use 'print filename ' or 'copy xx lpt1:' or any other networked >printer. >3. Once file printing is complete, have the file moved to >another directory >or delete it from 'printdir' >4. schedule a periodic job scheduler to execute NT shell script. > >There are some permission requirements to for the scheduler to >execute NT >shell script. > >First test printing of file from the 'printdir' in command >shell and then >incorporate same into shell script. > >If you prefer, you could use shell command to schedule >periodic execution of >shell script instead of job scheduler. > >HTH > >Shiva > > > >-----Original Message----- >Sent: Monday, June 30, 2003 10: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). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Baswannappa, Shiva > 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: Foelz.Frank 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: Baswannappa, Shiva 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).
