Problem binding long string datatype to Oracle CLOB column

[Cecil Onodera]

 Posted by:  Cecil Onodera 

Hello,

Current environment:

1. Oracle 9i, Release 9.2.0.1.0

2. Centura Team Developer 2.1 with PTF 4

While inserting a row which includes a long string variable into an Oracle
table with a CLOB column, I encounter the following Oracle error:

Oracle:24801[Oracle][ODBC][Ora]ORA-24801: illegal parameter value in OCI lob
function

I've been using the SqlSetLongBindDatatype( ) function after defining my
Insert statement:

Call SqlPrepare( hGlobalSql, sSqlString)

Set nDataType = 22

Call SqlSetLongBindDatatype(6, nDataType)

Call SqlExecute( hGlobalSql)

Can anyone recommend a corrective course of action?

Thank you for any insights and suggestions.

Cecil

[Tony]

 Posted by:  Tony 

It works for me with:

Call SqlSetLongBindDatatype(6, 23)

Since 23 is long binary which is a CLOB