Re: dbms_sql help

Ehm... why do you wrap it in a function to begin with? I mean, you can just as well do
select * from emp;

instead of :
select my_pack.my_func from dual;
and have a function defined that will do the select * from emp.

Why all the hassle?
And with execute immediate (9i and up, not 8i), it would be: execute immediate ('select * from emp'); No cursor prepare, execute, bind, etc, you would use with dbms_sql.

In the link provided, execute immediate has examples, too. But usually this approach leads to non-scalable applications. Received on Thu Mar 09 2006 - 09:18:26 CST