Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL output to printer?

Re: PL/SQL output to printer?

From: Eric L. Ma <mlq_at_ndi.net>
Date: Wed, 6 Jan 1999 20:42:32 -0500
Message-ID: <zjUk2.187$cT4.3758@newsfeed.slurp.net>


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 Wed Jan 06 1999 - 19:42:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US