Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add support to edit CLOBS #69

Open
acautin opened this issue Sep 26, 2018 · 2 comments
Open

Add support to edit CLOBS #69

acautin opened this issue Sep 26, 2018 · 2 comments
Assignees

Comments

@acautin
Copy link
Contributor

acautin commented Sep 26, 2018

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

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 added a commit that referenced this issue Sep 27, 2018
@c-bik
Copy link
Member

c-bik commented Sep 27, 2018

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.

@c-bik
Copy link
Member

c-bik commented Sep 27, 2018

@c-bik c-bik reopened this Sep 27, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants