[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: ORA-01461

On Tue, 25 Jan 2000, 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've gotten this several times on Windows machines using ODBC, but
usually only when the strings were getting to be 1500 long or so.
Unfortunately for your problem (maybe), I've always solved this by moving
the SQR to a Unix server and running it there, where I haven't encountered
a problem with it.

HTH,
-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com |  "In the beginning, there was nothing, which exploded"