Re: Converting Long Data to Varchar2(s)

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Wed, 07 Apr 1999 19:13:42 -0700
Message-ID: <370C10D6.A99@oriolecorp.com>

carl christianson wrote:
>
> 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

The 2,000 characters limit is valid for columns in tables, but you can have much longer VARCHARs (up to 32K I think) in PL/SQL. Should be more than enough.

--
Regards,

  Stéphane Faroult
  Oriole Corporation

---

http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs

---

Received on Wed Apr 07 1999 - 21:13:42 CDT