Re: How can I dynamically execute a procedure name?

On 14 Aug 2002 19:21:20 -0700, marcie.tietjen_at_westgroup.com (marcie) wrote:

>Brian,
>
>I've tried looking into execute immediately but can't get it to
>execute a procedure. The only examples I've been able to find execute
>a select, insert etc. I haven't been able to find an example or use a
>procedure with execute immediately.
>
>Any ideas?
>Thanks

SQL> CREATE Table Cow (Moo NUMBER);

Table created.

SQL> CREATE PROCEDURE A AS
  2 BEGIN
  3 INSERT INTO Cow VALUES(1);
  4 END;
  5 /

Procedure created.

SQL> CREATE PROCEDURE B AS
  2 BEGIN
  3 INSERT INTO Cow VALUES(2);
  4 END;
  5 /

Procedure created.

SQL> CREATE PROCEDURE C (D CHAR) AS
  2 BEGIN
  3 EXECUTE IMMEDIATE 'BEGIN ' || D || '; END;';   4 END;
  5 /

Procedure created.

SQL> CREATE PROCEDURE D AS
  2 BEGIN
  3 C('A');
  4 C('B');
  5 END;
  6 /

Procedure created.

SQL> EXECUTE D; PL/SQL procedure successfully completed.

SQL> SELECT Moo FROM Cow;

       MOO

         1
         2

HTH,
Brian Received on Thu Aug 15 2002 - 10:28:47 CDT