RE: printing out of Pl/SQL
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
RE: printing out of Pl/SQL
Frank, Could you use an extproc call to handle the printing of the file then deleting it? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, July 01, 2003 3: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
RE: printing out of Pl/SQL
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
RE: printing out of Pl/SQL
Hi Dick, Could you use an extproc call to handle the printing of the file then deleting it? I have never tried to use extproc, nor have I done dll function calls out of PlSQL. What version of Oracle can do this. We are using 8.0.6. Is it able to do that ? Someone give an example, on howto define .dll functions and call it ? any help is appreciated 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: Goulet, Dick [mailto:[EMAIL PROTECTED] Gesendet am: Dienstag, 1. Juli 2003 15:49 An: Multiple recipients of list ORACLE-L Betreff: RE: printing out of Pl/SQL Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, July 01, 2003 3: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
RE: printing out of Pl/SQL
Frank,
I've not done dll calls from Oracle as well, we use HP-UX and Linux, which I
believe is much simpler. Anyhow, along a similar lane, here's a snippet of extproc C
code that I've written to run an SQR from a PL/SQL call:
char *run_sqr(char *prog, char *uname)
{ FILE *sout = NULL;
FILE *lg = NULL;
char cmd[1000];
char bfr[200];
char *rval = NULL;
sprintf(cmd, sqr %s %s -I/opt/psoft/fsdev75/sqr/
-M/opt/psoft/fsdev75/sqr/allmaxes.max -XB\n\0,
prog, uname);
sout = popen(cmd,r);
if(sout)
{ lg = fopen(/ora1/extproc.log,w);
fprintf(lg, %s, cmd);
while(fgets(bfr, sizeof(bfr), sout))
{ if(!strncmp(bfr, ERROR, 5)) break;
else fprintf(lg, %s, bfr);
}
pclose(sout);
fclose(lg);
}
else sprintf(bfr, Error runnign SQR\0);
rval = calloc(1, strlen(bfr)+3);
if(rval) strcpy(rval, bfr);
return(rval);
}
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, July 01, 2003 11:20 AM
To: Multiple recipients of list ORACLE-L
Hi Dick,
Could you use an extproc call to handle the printing of
the file then deleting it?
I have never tried to use extproc, nor have I done dll function calls out of
PlSQL.
What version of Oracle can do this. We are using 8.0.6. Is it able to do
that ?
Someone give an example, on howto define .dll functions and call it ?
any help is appreciated
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: Goulet, Dick [mailto:[EMAIL PROTECTED]
Gesendet am: Dienstag, 1. Juli 2003 15:49
An: Multiple recipients of list ORACLE-L
Betreff: RE: printing out of Pl/SQL
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, July 01, 2003 3: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
RE: printing out of Pl/SQL
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
Re: printing out of Pl/SQL
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).
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). -- 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).
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).
Re: printing out of Pl/SQL
And very easy to do in Perl, Windows or *nix. :) http://www.cybcon.com/~jkstill/util/debug_pipe/debug_pipe.html Jared On Friday 27 June 2003 11:04, Arup Nanda wrote: Or DBMS_PIPE - a little easier. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 27, 2003 11:40 AM You can dump the stuff in to AQ and then have shell script to dequeue it and print it . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 27, 2003 8:14 AM 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
RE: printing out of Pl/SQL
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).
RE: printing out of Pl/SQL
You should be more environmentally conscious and pipe this through compress prior to sending it to lpt1. -Original Message- dd if=your file of=/dev/lpt1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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).
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
RE: printing out of Pl/SQL
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).
Re: printing out of Pl/SQL
You can dump the stuff in to AQ and then have shell script to dequeue it and print it . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 27, 2003 8:14 AM 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: AK 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
RE: printing out of Pl/SQL
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 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
Re: printing out of Pl/SQL
in case of pipe you loose items in pipe if system gets down . Careful !!! -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 27, 2003 11:04 AM Or DBMS_PIPE - a little easier. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 27, 2003 11:40 AM You can dump the stuff in to AQ and then have shell script to dequeue it and print it . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 27, 2003 8:14 AM 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
RE: printing out of Pl/SQL
Title: RE: printing out of Pl/SQL
Dick,
this is 9i ... in 9ir2, oracle recommends that UFD parameter is going away, so use CREATE_DIR ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Message-
From: Goulet, Dick [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 27, 2003 2:15 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: printing out of Pl/SQL
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 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
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 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]
RE: printing out of Pl/SQL
Mladen,
Thanks, I was talking about 8.1 and earlier.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, June 27, 2003 3:24 PM
To: Multiple recipients of list ORACLE-L
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 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
Re: printing out of Pl/SQL
When the system gets down, does it get funky, too? ;-) --- AK [EMAIL PROTECTED] wrote: in case of pipe you loose items in pipe if system gets down . Careful !!! -ak __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel 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).
RE: printing out of Pl/SQL
Title: RE: printing out of Pl/SQL Are you using sqlplus? spool on ... do some work spoo out will that work for you? Just a guess ... it might Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Foelz.Frank [mailto:[EMAIL PROTECTED]] Sent: Friday, June 27, 2003 11:40 AM To: Multiple recipients of list ORACLE-L Subject: AW: printing out of Pl/SQL sounds like some Unix/Linux I am on NT / Oracle 8.0.6 Frank -Ursprüngliche Nachricht- Von: Gogala, Mladen [mailto:[EMAIL PROTECTED]] Gesendet am: Freitag, 27. Juni 2003 16:14 An: Multiple recipients of list ORACLE-L Betreff: RE: printing out of Pl/SQL dd if=your file of=/dev/lpt1 Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -- 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). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: printing out of Pl/SQL
Title: RE: printing out of Pl/SQL oops ... it should be "spool out" Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Jamadagni, Rajendra Sent: Friday, June 27, 2003 4:55 PMTo: Multiple recipients of list ORACLE-LSubject: RE: printing out of Pl/SQL Are you using sqlplus? spool on ... do some work spoo out will that work for you? Just a guess ... it might Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Foelz.Frank [mailto:[EMAIL PROTECTED]] Sent: Friday, June 27, 2003 11:40 AM To: Multiple recipients of list ORACLE-L Subject: AW: printing out of Pl/SQL sounds like some Unix/Linux I am on NT / Oracle 8.0.6 Frank -Ursprüngliche Nachricht- Von: Gogala, Mladen [mailto:[EMAIL PROTECTED]] Gesendet am: Freitag, 27. Juni 2003 16:14 An: Multiple recipients of list ORACLE-L Betreff: RE: printing out of Pl/SQL dd if=your file of=/dev/lpt1 Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -- 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). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: printing out of Pl/SQL
Title: RE: printing out of Pl/SQL Isnt it: spool off? Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jamadagni, Rajendra Sent: Friday, June 27, 2003 4:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: printing out of Pl/SQL oops ... it should be spool out Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Jamadagni, Rajendra Sent: Friday, June 27, 2003 4:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: printing out of Pl/SQL Are you using sqlplus? spool on ... do some work spoo out will that work for you? Just a guess ... it might Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Foelz.Frank [mailto:[EMAIL PROTECTED]] Sent: Friday, June 27, 2003 11:40 AM To: Multiple recipients of list ORACLE-L Subject: AW: printing out of Pl/SQL sounds like some Unix/Linux I am on NT / Oracle 8.0.6 Frank -Ursprüngliche Nachricht- Von: Gogala, Mladen [mailto:[EMAIL PROTECTED]] Gesendet am: Freitag, 27. Juni 2003 16:14 An: Multiple recipients of list ORACLE-L Betreff: RE: printing out of Pl/SQL dd if=your file of=/dev/lpt1 Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -- 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).
RE: printing out of Pl/SQL
Title: RE: printing out of Pl/SQL
spool off will close the file ... spool out will _print_
it.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts, having an opinion is an art !
-Original Message-From: Igor Neyman
[mailto:[EMAIL PROTECTED]Sent: Friday, June 27, 2003 5:30
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
printing out of Pl/SQL
Isn't it: "spool
off"?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original
Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jamadagni,
RajendraSent: Friday, June
27, 2003 4:15 PMTo: Multiple
recipients of list ORACLE-LSubject: RE: printing out of
Pl/SQL
oops ... it
should be "spool
out"
Raj
Rajendra dot Jamadagni at
nospamespn dot com All Views expressed in
this email are strictly personal. QOTD: Any
clod can have facts, having an opinion is an art !
-Original
Message-From:
Jamadagni, Rajendra Sent:
Friday, June 27, 2003 4:55 PMTo: Multiple recipients of list
ORACLE-LSubject: RE:
printing out of Pl/SQL
Are you using sqlplus?
spool on ... do some work spoo out
will that work for you? Just a guess ... it
might Raj
Rajendra dot Jamadagni at
nospamespn dot com All Views expressed in this email are strictly
personal. QOTD:
Any clod can have facts, having an opinion is an art !
-Original Message- From: Foelz.Frank [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 27, 2003
11:40 AM To:
Multiple recipients of list ORACLE-L Subject: AW: printing out of Pl/SQL
sounds like some Unix/Linux
I am on NT / Oracle 8.0.6
Frank
-Ursprüngliche Nachricht-
Von: Gogala, Mladen [mailto:[EMAIL PROTECTED]]
Gesendet am: Freitag, 27.
Juni 2003 16:14 An: Multiple recipients of list
ORACLE-L Betreff: RE: printing out of
Pl/SQL dd if=your file
of=/dev/lpt1 Mladen Gogala Oracle DBA Phone:(203) 459-6855
Email:[EMAIL PROTECTED] -- 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).
This e-mail
message is confidential, intended only for the named recipient(s) above and may
contain information that is privileged, attorney work product or exempt from
disclosure under applicable law. If you have received this message in error, or are
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000
and delete this e-mail message from your computer, Thank
you.*2
RE: printing out of Pl/SQL
Title: RE: printing out of Pl/SQL Nope. The "spool out" command goes directly to the default printer, while "spool off" only stops spooling. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]Sent: Friday, June 27, 2003 5:30 PMTo: Multiple recipients of list ORACLE-LSubject: RE: printing out of Pl/SQL Isnt it: spool off? Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jamadagni, RajendraSent: Friday, June 27, 2003 4:15 PMTo: Multiple recipients of list ORACLE-LSubject: RE: printing out of Pl/SQL oops ... it should be "spool out" Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Jamadagni, Rajendra Sent: Friday, June 27, 2003 4:55 PMTo: Multiple recipients of list ORACLE-LSubject: RE: printing out of Pl/SQL Are you using sqlplus? spool on ... do some work spoo out will that work for you? Just a guess ... it might Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Foelz.Frank [mailto:[EMAIL PROTECTED]] Sent: Friday, June 27, 2003 11:40 AM To: Multiple recipients of list ORACLE-L Subject: AW: printing out of Pl/SQL sounds like some Unix/Linux I am on NT / Oracle 8.0.6 Frank -Ursprüngliche Nachricht- Von: Gogala, Mladen [mailto:[EMAIL PROTECTED]] Gesendet am: Freitag, 27. Juni 2003 16:14 An: Multiple recipients of list ORACLE-L Betreff: RE: printing out of Pl/SQL dd if=your file of=/dev/lpt1 Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -- 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).
