Re: Output from PL/SQL block
From: <fgreene_at_hayes.com>
Date: 8 Oct 93 08:18:25 EDT
Message-ID: <8070.2cb52251_at_hayes.com>
Date: 8 Oct 93 08:18:25 EDT
Message-ID: <8070.2cb52251_at_hayes.com>
In article <1993Oct7.093833.458_at_ecc.tased.edu.au>, it_mitch_at_ecc.tased.edu.au writes:
> Does anyone know how to produce output from a PL/SQL block
> without SELECTing into a temporary table ?
>
Unfortunately, you have answered your own question. PL/SQL output can ONLY
be routed to tables. With Reportwriter, however, you can output directly
to a print device. The NEW Reportwriter (Oracle Report I think) has
PL/SQL built into it. Hence, with the new product, you will have the best
of both worlds.
| Frank Greene DELPHI SYSTEMS Inc | _/_/_/ _/_/_/ | | Telephone [615] 458-6032 | _/_/ _/_/ | | Internet 74200.427_at_compuserve.com | _/_/ _/_/ _/_/_/ | | Compuserve 74200,427 | _/_/ _/_/ _/_/ | | 324 Ootsima Way | _/_/ _/_/ _/_/ | | Loudon, TN 37774 | _/_/_/ _/_/_/ _/_/_/ | ---------------------------------------------------------------------------- | Of course, any opinions or suggestions are strictly my own | ----------------------------------------------------------------------------Received on Fri Oct 08 1993 - 13:18:25 CET