Home » SQL & PL/SQL » SQL & PL/SQL » pcl commands
pcl commands [message #187032] Thu, 10 August 2006 10:35 Go to next message
Messages: 3
Registered: August 2006
Junior Member

Can any one help

I want to create an sql report that produces a text file and with in that file I want to embed pcl commands in order to call a macro stored on the printer. (form overlay)

Thanks for any help

Re: pcl commands [message #188179 is a reply to message #187032] Thu, 17 August 2006 06:35 Go to previous message
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
Oracle lets you put literals in a sql statement.

>username: <your username>
>password: <your password>
spool yourfile.txt
set linesize 100
set pagesize 0

select 'your pcl command', <the stuff you want printed> ...
from ...
order by ...
Now edit yourfile.txt the take out the sql commands and commit;
send the file to your printer.
Previous Topic: When I use weak REF CURSOR to use BULK COLLECTION
Next Topic: inserting
Goto Forum:

Current Time: Mon Aug 21 12:53:33 CDT 2017

Total time taken to generate the page: 0.01003 seconds