Re: ORA-00997 8i trigger long raw problem

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Tue, 12 Jul 2005 19:54:44 -0700
Message-ID: <E4OdnXXXS8SpH0nfRVn-vA@comcast.com>

"Steve" <saustin_at_hsius.com> wrote in message news:1121184021.835917.149040_at_g44g2000cwa.googlegroups.com...
> Thanks Jim. Am unfortunately forced into dealing with this !%!%%! for
> the next year. Do you have any old trigger code samples you would be
> willing to share that show a successful conversion to clob ? Have seen
> the ask Tom samples but they are clear as mud.
> Steve.
>

2 ways. pl/sql varchar2 which is limited to 32K. If it is longer than that then you are going to have to use dbms_sql to deal with it piecewise. See the pl/sql supplied packages dbms_sql for using the dbms_sql package.

Lobs are dealt with in a whole different manner. Jim Received on Tue Jul 12 2005 - 21:54:44 CDT