Re: PL/SQL varuable or SQLPLUS bind variable passed to UNIX ksh script

On 10 Jul 1997 21:00:33 GMT, bp_at_msg.ti.com (Bill Pry) wrote:

>We've not been able to find a way to:
>1. Have sqlplus do anything with a bind variable except display it or
>use it in a procedure call; that is, there doesn't appear to be a way to
>use it in an exit statement so that the UNIX script can see the value
>($?).
>
>2. Execute a host command like "export STATUS = :status" in PL/SQL or
>in SQLPLUS.
>
>What is the best way to get sqlplus bind variable or a PL/SQL variable
>returned to the shell script?
>
>Thank you for your support
>Bill & Karla
>
Check out Plex (PL/SQL Extender) which is free. Don't know the site off-hand but do a search and it will pop right up. Designed for exactly this, uses dbms_pipes and something else.
>

Brad Stauf
Applied Technologist at Solbourne
-Oracle know-how for your business
bstauf_at_solbourne.com
(303)-417-2834
Boulder, CO Received on Fri Jul 11 1997 - 00:00:00 CEST