ODBC SQL_LONGVARCHAR problems

I have an ODBC program that uses SQLBindParameter followed by SQLExecute to insert character data. It is working fine to Access and SQLServer but we're having trouble with Oracle. We originally tried defining the fields in the Oracle database as CLOB, but that didn't work. Then we tried VARCHAR2 which was what was suggested to us by Oracle, but we still get an error saying

ORA-01461 can bind a LONG value only for insert into a LONG column

There are a couple of problems with using a LONG column. One is that one of our tables has two of these fields, and you can only have one LONG per table. But even in the table where we had only one, when we change it to a LONG, the data gets truncated to about 120 characters.

any ideas on how to get this character data over to Oracle? The program needs to work on databases other than Oracle also, since most of our customers don't use Oracle.

Mira Lieberman mira_at_primus.com Received on Wed Apr 07 1999 - 12:50:31 CDT