RetrievingTriggers Souce Code

From: <armaghan_at_my-deja.com>
Date: Fri, 10 Sep 1999 03:12:57 GMT
Message-ID: <7r9svh$h4c$1@nnrp1.deja.com>

Hi,

Can somebody please tell me some easy way how can I retrieve triggers source code from dba_triggers using PL/SQL into a text file?

I can do it in SQL Plus with SET LONG but having problems doing it in PL/SQL. UTL_FILE.PUT_LINE is limited to 1022 characters so I cannot simply SELECT the column in a PL/SQL VARCHAR2 variable and then use PUT_LINE.

My source code is well under 32k (VARCHAR2 size limit).

Even a small hint will be helpful.

regards,
M. Armaghan Saqib
SQL Link for XL. A free tool to integrate Oracle with XL, Dev2k Tutorial with sample GL source code and other things. Click: http://www.geocities.com/WallStreet/Floor/8484/ (If you already use these then tell your colleages and friends)

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Sep 09 1999 - 22:12:57 CDT