Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Converting Long Data to Varchar2(s)

Converting Long Data to Varchar2(s)

From: carl christianson <cchristianson_at_knowledgesoft.com>
Date: Wed, 07 Apr 1999 14:20:48 -0400
Message-ID: <370BA200.E97813F3@knowledgesoft.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

Received on Wed Apr 07 1999 - 13:20:48 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US