Re: I need help with store procedure Dynamic

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sun, 19 Sep 1999 11:56:12 -0400
Message-ID: <HAflN11ovHVO1iIq2vVElrmm5JgZ@4ax.com>

A copy of this was sent to "Sergio Bonich Dinamrca" <SBONICH_at_CVMAIL.CL> (if that email address didn't require changing) On Sat, 18 Sep 1999 11:28:36 -0300, you wrote:

In oracle8.0 and below:

create or replace procedure execute_immediate( sql_stmt in varchar2 ) as

    exec_cursor integer default dbms_sql.open_cursor;     rows_processed number default 0;
begin

    dbms_sql.parse(exec_cursor, sql_stmt, dbms_sql.native );
    rows_processed := dbms_sql.execute(exec_cursor);
    dbms_sql.close_cursor( exec_cursor );

end;
/

              create or replace  procedure demo(name in varchar2) is
              begin
                   ---  call other procedure the name is demo2()
                   execute_immediate( 'begin ' || NAME || '; end;' );
              end demo;

In Oracle8i, release 8.1:

              create or replace  procedure demo(name in varchar2) is
              begin
                   ---  call other procedure the name is demo2()
                   execute immediate 'begin ' || NAME || '; end;';
              end demo;

>Example 1:
>
> create o replace procedure demo() is
>
> begin
>
> --- call other procedure the name is demo2()
> demo2()
>
> end demo()
>
>i need what the name the second procedure not is a know name, i need second
>procedure variable
>
>
>example 2 :
>
> create o replace procedure demo(name) is
>
> begin
>
> --- call other procedure the name is demo2()
> NAME()
>
> end demo()
>
>
>

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sun Sep 19 1999 - 10:56:12 CDT