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

XML data type question #261

Open
tomasjura opened this issue Jun 10, 2024 · 1 comment
Open

XML data type question #261

tomasjura opened this issue Jun 10, 2024 · 1 comment

Comments

@tomasjura
Copy link
Contributor

Hi Kubo

Is it planned support for the XML data type (https://docs.oracle.com/en/database/oracle/oracle-database/19/lnoci/oci-support-for-xml.html)? How difficult would be to implement this feature? (A dream is an integration with Nokogiri library without XML serialization and parsing.)

I know that any time the input bind parameter can be wrapped by XMLTYPE constructor, but it is annoying to to write this cast for each case.

A longer story:
Oracle has a very good support for XML processing ( XSLT , XQuery 3.0 with update facility, xmldiff , ... ). I would like to give a simple access of those features for my users. Unfortunately no existing user interactive client supports the binding of XML (CLOB) from an external file, which makes usage of those functionalities even more difficult for big XMLs. The situation with Python is the same. Seems that only JDBC supports the XML bindings. But JDBC does not support named parameters (bindings) which are nice for an interactive usage.

@kubo
Copy link
Owner

kubo commented Jun 11, 2024

No plans.

I tried it and removed it by f2a64c8 about 13 years ago.
I don't remember why I gave up.

Here is the code just before it was removed.
https://github.com/kubo/ruby-oci8/blob/0bb6cd3/ext/oci8/xmldb.c
It looks that it tried to create REXML objects from xmlnode in oci8_make_rexml().

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants