Re: Insert failure

Hello

Anyone who know to get the '&' not to be used as a prompt ?? I have a huge number of such url's in a raw fil witch i want to load into my table with SQL Loader.
So i can't press return manualy for all this :-)

Best regards Rune Myrhaug

"Alistair Thomson" <thomson_alistair_at_no.spam.yahoo.co.uk> wrote in message news:ap5pg0$kfb$1$8302bc10_at_news.demon.co.uk...
> Hi
>
> 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:24:47 CDT