Hi Mariano
> CREATE TABLE test_large_columns (
> large_clob CLOB,
> large_nclob NCLOB,
> large_blob BLOB
> ).
>
> INSERT INTO test_large_columns (large_clob, large_nclob, large_blob)
> VALUES (''large_clob_data'' , ''large_nclob_data'' , EMPTY_BLOB())
>
> SELECT * FROM test_large_columns
>
> But when I am trying to fech the raw, using odbx_row_fetch I get the
> error:
> 'ORA-00932: inconsistent datatypes: expected CHAR got BLOB'This seems to be related to the problem that the odbx_lob_* functions are not available und CLOB/BLOB values are automatically converted to strings. It works for CLOBs but generates this error for BLOB values. Unfortunately, I think, BLOBs won't work until we get the odbx_lob_* functions for Oracle to work. Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc
signature.asc
Description: This is a digitally signed message part.
------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev
_______________________________________________ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
