[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

SQR converting string to Long



Hello,

I have a program that I wrote in SQR v. 3.0 that loads data from a text file
into an Oracle 7.3 table.    We just upgraded to Oracle 8 and SQR 4.2.3 and
now I get this error when I run it:

(SQR 5528) ORACLE OEXEC error -1461 in cursor 18:
   ORA-01461: can bind a LONG value only for insert into a LONG column

The field that is causing the problem is a varchar2(2000) column.  Records
are inserted just fine when that field is less than 30 characters long, but
any record with that field any longer is rejected with this error.  It seems
that SQR is converting the variable to a long, but that sounds like a dumb
thing for it to do when the variable is still so short.

Thanks,

Jim