RetrievingTriggers Souce Code
Date: Fri, 10 Sep 1999 03:12:57 GMT
Message-ID: <7r9svh$h4c$1_at_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 Fri Sep 10 1999 - 05:12:57 CEST