Problem inserting VARCHAR2(4000) using ODBC

From: Albert <no_spam_contactemt_at_bigfoot.com>
Date: Fri, 27 Sep 2002 15:28:33 +0100
Message-ID: <an1psi$1re$1@news7.svr.pol.co.uk>

Hi,

I am trying to insert a row with a VARCHAR(4000) sized element with the following statement in a C program using personal oracle and driver Oracle ODBC Driver 8.01.07.00:

    rc=SQLBindParameter(Hstmt, iPct, SQL_PARAM_INPUT, SQL_C_CHAR,

                      SQL_LONGVARCHAR, MAX_CHAR, 0, szScrc_analysis, 0,

&cbScrc_analysis);

I have set MAX_CHAR = 4000.
I have also tried SQL_CHAR and SQL_VARCHAR in place of SQL_LONGVARCHAR with the same result.

I get no error above, but SQLExecute(Hstmt); gives ORA-1401 "Inserted value too large....."

What changes must I make?

Thanks Received on Fri Sep 27 2002 - 09:28:33 CDT