Home » RDBMS Server » Server Administration » SQL Output printing on HP Laser Jet printer (4000 N Seris)...
SQL Output printing on HP Laser Jet printer (4000 N Seris)... [message #370988] Sat, 29 July 2000 08:28 Go to next message
Raju
Messages: 74
Registered: March 1999
Member
I have the folowing SQL code.
set pagesize 50
set newpage 0
spool c:\sal.lst
select empno,empnm,sal
from sal
order by empno;
spool off

The environment is like this :
Client side : Work Station : Windows NT 4.0
Back end : Oracle 8.0.4 on RS/6000 (AIX 3.0)
When I print c:\sal.lst on HP laser printer,it does not skip page properly. Means second page's title (Company Name) should print on second page, instead it prints at the end on first page itself.
Why it is so ?
Kindly help me in this regard as I have to put my system under production environment in user area.

raju_padaria@hotmail.com
FAG Bearings India Limited
India
Vadodara - 39 00 13
Re: SQL Output printing on HP Laser Jet printer (4000 N Seris)... [message #371154 is a reply to message #370988] Thu, 07 September 2000 14:36 Go to previous message
Salman Khan
Messages: 51
Registered: September 2000
Member
Hi,

Two years ago I also went to the same problem and I could'nt solve the problem. But if you directly print on your printer then is work otherwise not. (mean not on network printer)
Previous Topic: Re: Command to drop all tables???
Next Topic: Error Handling...
Goto Forum:
  


Current Time: Sun Dec 22 11:28:31 CST 2024