Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Insert failure

Insert failure

From: Rune Myrhaug <runemy_at_netcom.no>
Date: Wed, 23 Oct 2002 11:08:16 +0200
Message-ID: <ap5oun$b57$1@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)&destinationU 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 Wed Oct 23 2002 - 04:08:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US