K2InformaticsGmbH/erloci

Add support to edit CLOBS

Opened this issue · 2 comments

acautin commented

when trying to edit/insert a CLOB the driver returns Unsupported type in bind which I see is defined on

erloci/c_src/erloci_drv/marshal.cpp

Line 503 in 7b9d2fd

strcpy(r.gerrbuf, "Unsupported type in bind");

and I don't see SQLT_CLOB in the switch case, would it be possible to support this type ?.

cc @stoch

c-bik commented

Writing LOB (CLOB, BLOB and NCLOBs) through DDErl requires implementation of OCI LOB edit APIs as defined here https://docs.oracle.com/cd/B28359_01/appdev.111/b28395/oci17msc002.htm#i541721

LOBs requires special streaming API calls to insert them through bind variables (which probably inst current requirement for DDErl support). This is a non-trivial implementation so postponed / skipped in favor of NIF project!

@acautin
For dderl please construct the insert statements as follows:

insert into tab1(clob_column) values (to_clob(:SQLT_STR_CLOBBIN))

Update statements should have similar to_clob function calls.