ORA-01461

[Gary Murphy <gmurphy@AGCONSULT.COM>]

We are just installing PeopleSoft 7.5 which is running on Oracle 8 and SQR
4.3.4.
When we write any SQR program that inserts a value containing more than 29
characters
into a VARCHAR2 field (i.e., DESCR)  we get the following message:

**SQL-Error = ORA-01461: can bind a LONG value only for insert into a LONG
column

The field that is causing the problem is DESCR which is a VARCHAR2(30).
However, we
have tested other VARCHAR2 fields which are longer than 29 characters and
experience the
same problem.  Rows are inserted just fine when the value is less than 30
characters
long, but any value longer than 29 characters causes this problem.

I noticed there were several other entries in SQRUG, but I didn't see a viable
answer.  This
does not appear to be a data problem, and running SQRMAKE.SQR did not resolve
the
problem.

Any help would be appreciated.

Thanks, Gary