Re: Understanding EXECUTE IMMEDIATE

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 26 Sep 2005 21:37:12 +0200
Message-ID: <43384dd2$0$19252$626a14ce@news.free.fr>

"pbewig_at_swbell.net" <pbewig_at_gmail.com> a écrit dans le message de news: 1127763128.745924.313410_at_f14g2000cwb.googlegroups.com...
|I am having trouble understanding the scope rules of
| EXECUTE IMMEDIATE. Consider this example, which causes
| a PLS-201 error "identifier 'SAY_HELLO' must be declared":
|
| declare
| procedure say_hello is
| begin
| dbms_output.put_line('hello');
| end;
| begin
| execute immediate 'begin say_hello; end;';
| end;
|
| How can I work around this problem? How can I write
| a procedure that takes an argument? How can I write
| a package including a procedure that calls back to a
| procedure in my client code?
|
| Phil
|

declare

        procedure say_hello is
        begin
            dbms_output.put_line('hello');
        end;
    begin
        say_hello;

    end;
/

Regards
Michel Cadot Received on Mon Sep 26 2005 - 14:37:12 CDT