Re: Dynamic SQL in PL/SQL

kmku_at_hkusua.hku.hk (Ku Kam Ming) wrote:

>Where and how I can get info. of using dynamic SQL in PL/SQL?
>BTW, I found that there are PL/SQL package dbms_sql which can execute
>dynamic SQL, which manuals mention those packageS???
 

>Thanks,
>--
>**********************************************************************
>Kam-ming Ku (kmku) Big-5:[ÅUÀA©ú] GB: ~{9K=uCw~}
>Assistant Computer Officer
>Main Library, Email : kmku_at_hkucc.hku.hk
>The University of Hong Kong, Tel. : (852) 2859-8068
>Pokfulam Road, Hong Kong. Fax. : (852) 2858-9420
>*********************************************************************
>

Hi kmku,

        Please print the DBMS_SQL package body from ORACLE. It will give you more idea about its functions and procedures. I have implemented it in my project. It is working great.

Method of getting the source :

SQL > spool on
SQL > select text from all_source where name = 'DBMS_SQL';
SQL > spool off

Then print the on.lst to your printer. It has examples and flow chart.

Hope this helps. IF you still have trouble, send a email to prabha_at_lilly.com (office) or parbha_at_iquest.net (home)

Have a nice day.

                                prabha Received on Thu Jan 18 1996 - 00:00:00 CET