Re: ORA-01461

[Nathan Stratton Treadway <nathant@ONTKO.COM>]

On Tue, Jan 25, 2000 at 07:35:01AM -0800, Gary Murphy wrote:
> 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
>
[...]
> 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.

The symptoms you describe are exactly what I experienced when we
upgraded to Oracle 8 and didn't relink SQR against the new Oracle
libraries.  You didn't say what platform you were using, but I would
double-check that you are actually running the copy of the SQR
executable that has been relinked with the new libraries.

Also, make sure your Oracle installation is correct (make sure SQL*Plus
runs, check $ORACLE_HOME on Unix, etc.).

If these ideas fail, I would contact Brio tech support....

                                                Nathan
----------------------------------------------------------------------------
Nathan Stratton Treadway  | Ray Ontko & Co. | Software consulting services
nathant@ontko.com         | Richmond, IN    | http://www.ontko.com/