Re: Dynamic Call to PL/SQL stored Procedure

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 6 Aug 1998 04:56:08 GMT
Message-ID: <6qbd18$l8r1@hendrix.csufresno.edu>

In article <6q7usa$41e$1_at_nnrp1.dejanews.com>, <dov_at_healthstreet.com> wrote:
>hello,
>
>Is there a way to call a PL/SQL procedure dynamically i.e. storing the called
>procedure name in a variable and usingthe variable in the CALL instead of
>explicit procedure name ?

Thomas Kyte has posted an Execute_Immediate dynamic procedure that might do what you want. You could call a procedure that had no parameters, or only IN parameters passed as literals, but I don't think it would work where you needed to get any data back.

I have a copy somewhere, if you can't find it in Deja News.

Steve Cosner Received on Wed Aug 05 1998 - 23:56:08 CDT