Re: Help on inserting strings...

In article <38FDC6CE.8A2217AC_at_uhb.fr>,
  Joel SEGUILLON <Joel.Seguillon_at_uhb.fr> wrote:
> Thanks,
> That's a good idea. But i would be nicer if i could use only SQl
> orders...
> I tried to split my string like this : insert into values ('1999
> charaters' || '1999 characters' || ...) but the probleme is the same.
> Anyone have an idea ?
> Bye.
>

the ONLY way to do it, the ONLY way, is to use a bind variable.

the plsql thing will work up to 32k.

Beyond 32k you will have to use DBMS_SQL and dynamic sql or a 3gl.

--
Thomas Kyte                              tkyte_at_us.oracle.com
Oracle Service Industries
http://osi.oracle.com/~tkyte/index.html
--
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.