Re: Problem inserting VARCHAR2(4000) using ODBC

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 27 Sep 2002 15:23:27 GMT
Message-ID: <3D9477DF.9103E7BA@exesolutions.com>

Albert wrote:

> 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

Try sending 3999 bytes.

Daniel Morgan Received on Fri Sep 27 2002 - 10:23:27 CDT