Re: Understanding EXECUTE IMMEDIATE

Again, I'm not executing insecure code entered bya user during the run of the program. I'm executing trusted code written by a programmer as part of a PL/SQL client.

To my lispish eyes, EXECUTE IMMEDIATE looks a lot like eval. But I am learning that it's not. The only environment that EXECUTE IMMEDIATE can see is the database; it can see nothing in the enclosing PL/SQL program.

That means my client code will have to store the called-back procedure in a known place in the database, so that the package can call it when needed.

Phil Received on Tue Sep 27 2005 - 07:36:49 CDT