GaryAshford
Programmer
Hi.
Can't find anything specific about this in the Oracle Docs:
Does anyone know if it is possible to bind a CLOB or an NCLOB column in the WHERE clause of a SELECT statement?
e.g.
SELECT * from table WHERE clobcol = :clobval
(I am writing an application using the OCI so the mechanics of defining and binding CLOBS/NCLOBS is already in place)
Currently, I am getting the error:
ORA-00932: inconsistent datatypes: expected - got CLOB
Note that the "expected" data type is missing.
I have successfully bound an OCILocator to the column yet this message is being returned from OCIStmtExecute.
Normal inserts/updates of CLOBS/NCLOBS are working OK.
Any help much appreciated.
Can't find anything specific about this in the Oracle Docs:
Does anyone know if it is possible to bind a CLOB or an NCLOB column in the WHERE clause of a SELECT statement?
e.g.
SELECT * from table WHERE clobcol = :clobval
(I am writing an application using the OCI so the mechanics of defining and binding CLOBS/NCLOBS is already in place)
Currently, I am getting the error:
ORA-00932: inconsistent datatypes: expected - got CLOB
Note that the "expected" data type is missing.
I have successfully bound an OCILocator to the column yet this message is being returned from OCIStmtExecute.
Normal inserts/updates of CLOBS/NCLOBS are working OK.
Any help much appreciated.