Re: RetrievingTriggers Souce Code

From: Karen Abgarian <karen.abgarian_at_fmr.com>
Date: Fri, 10 Sep 1999 10:37:14 -0400
Message-ID: <37D91799.A457C8D4@fmr.com>

Hi there,

I would suggest retrieving pieces using DBMS_SQL's long-processing procedures
and then to process them using UTL_FILE.

Regards,
Karen Abgarian.

armaghan_at_my-deja.com wrote:

> 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 - 09:37:14 CDT