Re: Insert failure

From: Alistair Thomson <thomson_alistair_at_no.spam.yahoo.co.uk>
Date: Wed, 23 Oct 2002 10:17:56 +0100
Message-ID: <ap5pg0$kfb$1$8302bc10@news.demon.co.uk>

I inserted the row into a table I have and it worked okay apart from asking for values for
Enter value for event:
Enter value for destinationurl:
Enter value for badlogin:
as these text strings follow the '&' which is used as a prompt. I just pressed return and the row was inserted. I'm using 8.1.7 EE

Alistair

"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 Wed Oct 23 2002 - 04:17:56 CDT