I'm working on a PL/SQL stored procedure to update a LONG column with up to
a 2GB string. When it's done I'll put it on my web site. Probably a week or
so to finish it.
--
- Dan Clamage
http://www.telerama.com/~dclamage
If you haven't crashed the Server,
you haven't been trying hard enough.
Thomas Kyte <tkyte_at_us.oracle.com> wrote in article
<35b47ba1.29141793_at_192.86.155.100>...
> >I am trying to insert text into a Long datatype, but I get this error.
> >ORA-01704: string literal too long
> One method in SQL plus and other tools that can run plsql that works upto
32k is
> The pl/sql variable can be initialized to upto 32k of static text. It
can then
> be inserted into the table (it is a bind variable, not a constant at that
> point).
> So, that put a 24,726 character string into the table...
Received on Thu Jul 16 1998 - 23:31:53 CDT
