| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle and Barcode Printing
On 17 Feb 1999 01:11:44 GMT, noodles_at_aol.com (Noodles) wrote:
>
>I'm working on a project where the customer needs to print out a barcode
>corresponding to a data value in a column. I've heard Zebra barcode printers
>are nice but they seem VERY pricey. Plus I'm not sure how Oracle would talk to
>a a printer except maybe through some external library call within a Pro*C
>program (?). Can anybody point me in the right direction ?
>
>TIA,
>Cliff
We use Zebra printers here on the manufacturing floor exclusively. These things are built like tanks. For high volume applications, they're worth the money.
Caveat: The following is MS-Windows specific.
We've got a number of applications written in Oracle Forms 4.5 that print to the Zebra quite nicely. The trick is to use text_io, and open up the LPTn: port, and print directly to it. No external calls or software is necessary.
This does require that the ZPL be generated by the application. We've got stored ZPL streams, and do runtime substition for embedded tokens.
As a side note, the application I've got beta-testing right now runs a stored procedure to verify factory test results (generally 2 selects), and spins through a multi-record block to generate the print stream. Even using a wedge scanner on a 486 DX4/100 system with 16 mb RAM, I have a hard time getting ahead of the Forms runtime.
 |
 |