Oracle, Web, Script, SQLserver, Tips & Trick

June 6, 2011

Filed under: dev6i,oracle — sikathabis @ 9:35 am
Tags: ,
Happy 2011 to everyone. I have been using TEXT_IO.FOPEN (‘LPT1’, ‘w’) in oracle form to sent text to LPT port printer without having any problem but nowadays most PC come with USB port and hence my programs failed to execute such command. Does anyone know or has any idea how to use TEXT_IO.FOPEN to sent text to USB printer direct?

Thank you and best regards.


Hi TH Cheng

If you are using a new computer with an existing printer that still has a parallel connector, you could buy a USB to Centronics cable. When connected, it shows up as a parallel port in the hardware list.

Or if the printer’s USB or networked, you could share it on your own PC then map a network path (net use LPT1 \\\printershare). I can’t remember if the /persistent:yes option works for LPT ports.

Or better yet, hope that an Oracle guru tells you how to amend the command for a USB port, but I’m not that guy!


/persistent:yes does work for LPT ports (at least on Windows XP Professional).

1. Most of the printer formats were removed from printers when windows started doing all the rendering work and dos does not have any provision for virtual ports such as USB. You have a couple of options. Use a serial port and send the output through a serial to USB converter, the results may be interesting as there may not be any CRLF commands in the text steam. The other is to use dos2usb from

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a free website or blog at



Teknologi Pendidikan

Just another weblog


Jurnalisme Yang Dapat Dipercaya

Tonk Kosonk Baonk Bunyinya

Penampungan Serapah Tanpa Sumpah

Qey050489's Blog

Ayo Bangkit sobat..!!!!!

B. S. Totoraharjo

Orang Desa Yang Mencintai Desa dan Kebudayaannya

culturekitchen foodlab

New Food and Art in Yogyakarta

Wahyu Catur Wibowo

Musafir Dunia Maya

SQL.... Still Learning

My Reference on SQL Server


"Tuhan tidak menuntut kita untuk menang. Tuhan hanya meminta kita untuk berjuang tanpa henti.” -ean-


Street Photography is like a box of a chocolates, you're never know what you're gonna get - Thomas Leuthard -

Be a good Moeslim

Menuju Pribadi Muslim Sejati yang Bertaqwa


Manajemen Sholat, renungan spiritual, Teknologi Informasi

Pelangi di khatulistiwa....

Mari berbagi kebaikan, pengalaman dan senyum denganku


Ceritanya saya, Pikirannya saya, Hatinya saya


sikathabis semua informasi disini

%d bloggers like this: