Sending file to Printer

[ba1234]

Hi
Any one help me how to work this

Declare
l_seq number;
begin
Select .Next_Val
into l_seq
from dual;
Select statement to get data from table
and write that data into file with extension l_seq
end;
/
Using the following command i need to send that file
to Printer.

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

Thanks

[marist89]

Can't do that (easily) with PL/SQL. I'd suggest just using a script with sqlplus.

[ba1234]

Hi Jeff Hunter

Thank you for your reply, Can i get any sample, i am using sqlplus only.

Thanks

[marist89]

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