DBD::Oracle and XMLType


Is there any way to bind a CLOB into the XMLType.createxml() call?

The createXML has 4 different signatures, one is varchar2, one is clob.

If the data is larger than 32k, I need to bind in a clob, but I am not really sure how to do it.

I read the DBD::Oracle docs and looked at the examples for manually using the ora_lob methods, but I am not sure if I can use this or notI might be able to.

Currently, I let the server(PL/SQL) do it. I pass a PL/SQL function a path, and PL/SQL creates the temporary lob and returns it to the createxml constructor, but if the server cannot access the file, this isn't an option. So I want to understand whether I can call this type method and pass it a CLOB directly from Perl.

I could insert the CLOB in another column using the traditional approach of getting the lob locator for the column and writing the clob data, and than calling another statement to create the xmltype from the CLOB column I just inserted, but I would rather go directly to the xmlType than insert another column.

any ideas?

Job

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com