Re: ORA-01461

[Gary Murphy <gmurphy@AGCONSULT.COM>]

We got it to work!  The problem was definitely the SQRMAKE.  It turns out that
when the client was running the SQRMAKE this they were getting an error message
saying the C compiler could not be found.  Well, they didn't think this was
important.  Once that was resolved, and SQRMAKE was run successfully, the SQR's
now run fine.





Gary Murphy <gmurphy@AGCONSULT.COM> on 01/25/2000 07:35:01 AM

Please respond to sqr-users@list.iex.net

To:   SQR-USERS@list.iex.net
cc:
Subject:  ORA-01461




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