Re: SQR 4.3.2 buggy??????

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

On Mon, Jun 21, 1999 at 11:55:07AM -0500, the dragon wrote:
> OK, here's the situation.  If I execute POPO005.sqr (PO print) using autosys
> (a scheduling program) pointing to the 4.3.2 SQR executable, I get the
> following error:
>
> (SQR 5528) ORACLE OEXEC error -1461 in cursor 83:
>    ORA-01461: can bind a LONG value only for insert into a LONG column.
>
> if I execute from within PSoft process scheduler using the 4.2.3 executable,
> the program(s) complete successfully.

I've gotten this sort of error when the SQR binary ($SQRDIR/sqr) was
linked with the wrong version of the Oracle libraries.

If you go into the $SQRDIR/../lib/ directory, you should find a shell
script "sqrmake".  Try running this (as the unix user who owns the sqr
installation directory) to generate a new SQR binary linked to your
current oracle libraries.

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