Home » Fusion Middleware & Colab Suite » WebCenter Suite & Portal » Report
Report [message #77371] Fri, 07 June 2002 10:26 Go to next message
Thode
Messages: 1
Registered: June 2002
Junior Member
Hi all,
I am really new to sql programming. I need to create an error report. I am just using straight sql to select the data and "spool" it to a file (in Unix). Now how do I get the report to print? I tried "Spool out" but it's not printing. How do I set the printer?

Thanks-
Re: Report [message #77378 is a reply to message #77371] Mon, 01 July 2002 13:01 Go to previous message
Dhiren
Messages: 43
Registered: July 2002
Member
u need to do:

sql>spool a
sql>select * from emp;
sql> spool off
$lp a.lst
This will print to the default printer.
To have ur printer setup u need to run
lpadmin and have it set.
Dhiren
Previous Topic: Re: Portal 3 Login error: WWC-41439
Next Topic: About MOD_PL/SQL
Goto Forum:
  


Current Time: Tue Aug 11 17:45:33 CDT 2020