Re: PL/SQL output to printer?

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 Thu Jan 07 1999 - 01:05:04 CST