Re: Converting Long Data to Varchar2(s)

From: Diamond Geezer <seahorse2303_at_my-dejanews.com>
Date: Mon, 12 Apr 1999 11:24:50 GMT
Message-ID: <7esl5t$ekn$1@nnrp1.dejanews.com>

> > Hi all,
> > I need to be able to reverse engineer triggers out of a database.
> > Unfortunatly Oracle places the trigger body in a Long data type.
> > Converting this to varchar2 in PL/SQL is fine if it is below the 2000
> > character limit. Any thoughts on how to do this if it is longer then
> > that?
> > Cheers
> >
> > Carl Christianson

Carl,

You could always try using DBMS_SQL.COLUMN_VALUE_LONG to pull out chunks at a time. Have you seen a package called TOAD? (from www.quests.com). I use it to dump the source of trigger/packages etc to txt files.

Jason.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Apr 12 1999 - 06:24:50 CDT