Re: Dynamic SQL Execution in Stored Procedure

Kee P Luk wrote:
>
> Does anyone know if it's possible to dynamically execute a SQL statement
> in Oracle stored procedure or function?
>
> Thanks in advance
> Kee Luk
>

Yes, you can use "dbms_sql" package provided with the database. Look under ~oracle/rdbms/admin for dbmssql.sql file if you are using Unix. By the way, are you a student at MIT? I was class of '87.

-- 
Andy Yun			
Senior Consultant		(Work) 805-447-1791
InfoSys Corporation		(Fax)  818-227-4948
Woodland Hills, CA		(Email) ayun_at_amgen.com
"Premier Oracle RDBMS Consultants"
*** Disclaimer: These are the opinions of the poster not Amgen Inc.***