Xref: alice comp.databases.oracle.server:45644 Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!korova.insync.net!solomon.io.com!news-feeds.jump.net!nntp2.dejanews.com!nnrp1.dejanews.com!not-for-mail From: Diamond Geezer Newsgroups: comp.databases.oracle.server Subject: Re: Converting Long Data to Varchar2(s) Date: Mon, 12 Apr 1999 11:24:50 GMT Organization: Deja News - The Leader in Internet Discussion Lines: 21 Message-ID: <7esl5t$ekn$1@nnrp1.dejanews.com> References: <370BA200.E97813F3@knowledgesoft.com> <370C10D6.A99@oriolecorp.com> X-Article-Creation-Date: Mon Apr 12 11:24:50 1999 GMT X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows 98) X-Http-Proxy: 1.0 x10.dejanews.com:80 (Squid/1.1.22) for client 195.92.6.173 > > 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