Re: Help With procedures....

From: <michael_bialik_at_my-deja.com>
Date: Sun, 13 Feb 2000 21:00:57 GMT
Message-ID: <887627$9m8$1@nnrp1.deja.com>

Hi.

If you are using Oracle 8i then you can use native dynamic SQL otherwise you must use Oracle package DBMS_SQL.

HTH. Michael

In article <885937$2br$1_at_nnrp1.deja.com>, skudsi_at_my-deja.com wrote:
> Hi ,
> I need help on how to call a procedure from within another procedure
> based on a parameter. I have a procedure to which I pass the name of
> the proper procedure to execute. I don't want to use IF statments to
> execute the right procedure but to use the vriable name immediately.
>
> To Summerize :
>
> I need to see how I can do this:
> calling_proc( the_procedure)
> Begin
> EXECUTE the_procedure(....)
> END
>
> thanks for any help.
> Sam
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Feb 13 2000 - 15:00:57 CST