Re: Error on Insert

["ggravino@wesleyan.edu" <ggravino@MAIL.WESLEYAN.EDU>]

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