Re: [Q] Generic programming

On Tue, 30 Sep 1997 21:09:22 GMT, martinj(replace this with @)xs4all.nl (Martin Jesterhoudt) wrote:

>Hello,
>
>PROBLEM:
>I want to call a procedure by using a variable as procedurename, but
>don't know if this is possible. Can someone give me a hint? Thanks in
>advance...
>
>EXAMPLES:
>(which doesn't work):
>

[SNIPPED]
>-------------------------------------------------------------------------------
>--- Martin Jesterhoudt
>--- martinj(replace this by @)worldonline.nl
>-------------------------------------------------------------------------------

Hi Martin,

have a look at Oracle standard package DBMS_SQL. You can construct an anonymous PL/SQL block as a VARCHAR2 variable, use bind variables in this block, have DBMS_SQL execute it and then retrieve the values of your bind variables.

If you need any further help, feel free to send me an e-mail.

Hope this helps,
Peter

Peter Schneider
pschneider.ctj_at_metronet.de Received on Wed Oct 01 1997 - 00:00:00 CDT