Re: Error on Insert

[Michael Prodor <mprodor@QUALCOMM.COM>]

Just a typo. Sorry

At 09:18 AM 1/10/2001, you wrote:
>Is it a typo in your email or does the first SUBSTR not have a comma
>between $x and 0?  Don't know if this is the culprit since the displayed
>value looks OK:
>
>50 let $acc_file = substr($x 0,37)
>
>
>
>At 08:42 AM 1/10/01 -0800, you wrote:
> >Hey there Gurus! I have a simple SQR that is loading data into a table.
> >This was suppose to be a quick (down and dirty) data loader, but I've been
> >stumbling over the problem for a couple hours now.
> >
> >The table to insert into has 3 columns, all of which are defined as
> >character types.
> >
> >When I try to insert, I receive an error (which appears to be an Oracle
> >error). It appears that the last value, u_rec, is causing the error. Here
> >is the code:
> >
> >
> >    49    unstring $x by $sepchar into $macro_rec
> >     50    let $acc_file = substr($x 0,37)
> >     51    let $msg_type = substr($x,38,2)
> >     52    let #usg_rec = substr($x,40,250)
> >     53    let $u_rec = to_char(#usg_rec)
> >...
> >     86  ! Insert into the New table the Usage data
> >     87
> >     88  begin-sql
> >     89  INSERT into arbor.QC_Temp_Usg_Tab
> >     90  values
> >     91  ($acc_file,
> >     92   $msg_type,
> >     93   $u_rec);
> >
> >Here is the data and the error that occurs:
> >
> >Selecting usage records ...
> >acc_file -> ACC01_000921_202017.new_preprocessed:
> >msg_type -> 14
> >u_rec ->
> >8363008021026100000000000000000000000000000000000000000000000000000000000000
> >000000000000000000000000000000000000000000000000000000000000000
> >(SQR 5528) ORACLE OEXEC error -1461 in cursor 3:
> >    ORA-01461: can bind a LONG value only for insert into a LONG column
> >
> >Error on line 88:
> >    (SQR 3735) Could not execute SQL.
> >
> >It appears that Oracle is taking my string value and converting to a long
> >on insert and it cannot go into a character defined column.
> >
> >Any help would be appreciated!!!
> >
> >
> >--
> >Michael Prodor
> ><mprodor@qualcomm.com>
> >
> >Qualcomm - IT QWBS Business Systems



--
Michael Prodor
<mprodor@qualcomm.com>

Qualcomm - IT QWBS Business Systems