Re: ORA-01704: string literal too long

Adrian Randle wrote:
>
> Hi,
>
> Anyone any idea how to insert > 2000 chars into an Oracle LONG datatype,
> without getting ORA-01704: string literal too long.
> Field should hold up to 2 Gig!
>
> Any help greatly appreciated..
>
> Thanks

Using PL/SQL will let you get up to 32767 bytes ie

declare
x varchar2(32767)
begin
 insert into ... values (x)
end;

after that, you're typically looking at something in C - one of the reasons Oracle went with the better LOB's in 8.0+

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"