Re: PL/SQL output to printer?

Hi,

I have not used OWAS. However, I believe this can be done with Pro*C and a database procedure.
Database PL*SQL procedure should be called upon receipt of the purchase order notification. This procedure
will do two things:
1) Write purchase order details to a text. (Give a generic name to this text file by using sequences)
2) Write this text file name to a pipe (a memory area in the Oracle shared pool) by DBMS_PIPE function.

Pro*c program should be running/listening this pipe in the background. If something comes up, it prints the file.
You can delete this file as well. (Whatever you like).

Hakan

delete no after @ to reply

Note:
I can write a simple/sample app if you like. (Without OWAS since I did not work with it, It should be easy to pass parameters to a database side procedure).

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 Thu Jan 07 1999 - 19:44:31 CST