Re: DBD::Oracle and XMLType

On 04/28/2005 05:32 AM, Job Miller said:

After a little searching of archives, I found the same exact problem
and the same self-proposed workaround almost a year ago.  Is there a
better way without creating another column in a temp table? I
couldn't find a follow-up to this post.

There is an ORA_CLOB ora_type, but there is a 32KB limit when passing values to PL/SQL. So It appears that the workaround you found using an intermediate table is still needed for larger CLOBs.

http://search.cpan.org/dist/DBD-Oracle/Oracle.pm#Placeholder_Binding_Attributes

http://search.cpan.org/dist/DBD-Oracle/Oracle.pm#Handling_LOBs

Job Miller <jobmiller@xxxxxxxxx> wrote:

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

--
Mac :})
** I usually forward private questions to the appropriate mail list. **
Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
.