Re: ORA-01461

["Johnson, Dan" <Dan_Johnson@WRIGHTEXPRESS.COM>]

Does this happen for both &variables and $variables. It looks like Oracle
has data type conversion issue. For some reason it thinks you are inserting
a LONG data type in a varchar field. This looks like a call to Oracle or
Brio.

Good luck.


        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