Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: printing out of Pl/SQL

RE: printing out of Pl/SQL

From: Foelz.Frank <Foelz.Frank_at_Scheidt-Bachmann.de>
Date: Mon, 30 Jun 2003 01:53:08 -0700
Message-ID: <F001.005BBF77.20030630013438@fatcity.com> 





ok, I have tried this sample in the way :





create or replace procedure PrintTest(I_ROWS IN number) 
is

        i_CountedRows           number(6);
        fHandle                 UTL_FILE.FILE_TYPE;
begin
        fHandle:=UTL_FILE.FOPEN('c:\','lpt1','w',255);
        i_CountedRows:=0;
        While i_CountedRows <= I_ROWS LOOP
                UTL_FILE.Put_Line(fHandle,to_char(i_CountedRows));
                i_CountedRows:=i_CountedRows+1;
        END LOOP;
        UTL_FILE.fClose(fHandle); 




END;






The only thing that is done : creating a file lpt1 in c:\ and store it.
I have tried several combinations like  


          fHandle:=UTL_FILE.FOPEN('c:\','lpt1','w',255)
          fHandle:=UTL_FILE.FOPEN('lpt1:','','w',255)





etc........



Nothing :-(



I am on NT4 / Oracle 8.0.6



TNX




> Frank <





Scheidt & Bachmann GmbH


Gestaltung Parkhaussysteme


Breite Strasse 132


41238 Moenchengladbach


Phone  :  ++49 2166 / 266 - 837
Fax:      ++49 2166 / 266 - 615
e-mail :  mailto:[EMAIL PROTECTED]
URL    :  http://www.scheidt-bachmann.de
________________________________________________________________________







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: Gogala, Mladen [mailto:[EMAIL PROTECTED]

>Gesendet am: Freitag, 27. Juni 2003 17:40

>An: Multiple recipients of list ORACLE-L

>Betreff: RE: printing out of Pl/SQL

>

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


Received on Mon Jun 30 2003 - 03:53:08 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US