Sending file to Printer
Any one help me how to work this
Select statement to get data from table
and write that data into file with extension l_seq
Using the following command i need to send that file
!lp -d $.l_seq
Its giving error, like l_seq not found. Can you tell me how
to get the sequence(l_Seq) and pass that to printer.
Last edited by marist89; 10-11-2004 at 01:07 PM.
Can't do that (easily) with PL/SQL. I'd suggest just using a script with sqlplus.
Hi Jeff Hunter
Thank you for your reply, Can i get any sample, i am using sqlplus only.
Basically, you have to declare a variable in your sqlplus script and then select the sequence number into it. Maybe some other kind soul will have the time to write the code for you...
Click Here to Expand Forum to Full Width