Re: PL/SQL output to printer?

If you insist on generating the ASCII-file at PL/SQL-level you can alwas use the UTL_FILE package. It
works fine, but you get the file on the Oracle Server. so you need to do some stuff to send the file
to a printerport. But I would not generate the file at PL/SQL-level, but that's a design issue.....

Johan Thorselius

Ken wrote:

> I don't think you understand. The user is sitting at home (in whatever state)
> ordering product over the web. After the user submits the order, it should be
> sent to a local printer so the order can be filled and shipped to the user. I'm
> sure this is a real life scenario, I just need to know if I can do it with
> OWS4.0 and Oracle 8 Enterprise DB together, or do I need more in order to
> accomplish it.
>
> Ken
>
> "Eric L. Ma" wrote:
>
> > The best you can do is after the user clicks the "Submit" button, on the
> > "Order Received" message screen display all the information he/she just
> > entered, and instruct him/her to use the "Print" functionality of the
> > browser to print out a hard copy.
> >
> > Eric Ma
> >
> > Ken <"ken"@nospam_at_bayline.com> wrote in message
> > news:369394B2.C1260EEF_at_bayline.com...
> > >
> > >Thanks for the reply. Maybe I should have asked if the OWS 4.0 has a way
> > >to send output to the printer. I'm using the PL/SQL cartridge in the OWS
> > 4.0
> > >What I want to accomplish is: when a user completes an order on the web, I
> > >want it to be sent to the printer for fulfillment of the order.
> > >
> > >Ken
> > >
> > >Ed Prochak wrote:
> > >
> > >> Sorry Ken. You're out of luck. PL/QL executes within the database,
> > >> so it knows nothing about external devices like printers. Maybe you
> > >> can call your procedure from Pro*C and print it that way.
> > >>
> > >> Ken wrote:
> > >>
> > >> > Is there a way to send the output of a select statement in PL/SQL
> > >> > to a printer? So far the only thing I can come up with is writing
> > >> > the output to a file and then using another program to print the files.
> > >> >
> > >> > I'm not trying to get any fancy reports, just plain ASCII text
> > character
> > >> > output
> > >> > to the printer from within the PL/SQL program, not with SQL*PLUS.
> > >> >
> > >> > ken
> > >

Received on Fri Jan 08 1999 - 01:32:14 CST