Use CLOBs.
"Rune Myrhaug" <runemy_at_netcom.no> wrote in message
news:ap5oun$b57$1_at_lise.netcom.no...
> Hello
>
> I'm trying to insert a long wap URL into a table with one column, deffined
> as VARCHAR2(700), like this:
>
> insert into wapUrl
>
values('http://mobile.club.nokia.com/m/c/n;SID=906Obd2iCgEI085Z!-1363274526!
> -1408186852!7501!7502?origin=m_login_main.jsp&event=link(login)&destinatio
nU
>
RL=http%3A%2F%2Fmobile.club.nokia.com%2Fm%2Fc%2Fn%3BSID%3D906Obd2iCgEI085Z%2
>
1-1363274526%21-1408186852%217501%217502%3Forigin%3Dm_rg_main.jsp%26amp%3Bev
> ent%3Dlink%28folder%29&badlogin=true');
>
> But i got error SP2-0232 insert value too long, must be smaler than
> 241.....but i have deffined my column to 700 char long and the string is
> only 333 char long...
>
> Can anybody help me ? Why doesen't this work and what can i do ?
>
> Best regards Rune Myrhaug
>
>
Received on Fri Oct 25 2002 - 08:14:04 CDT
