Error on Insert

[Michael Prodor <mprodor@QUALCOMM.COM>]

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 ->
8363008021026100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
(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