http://www.perlmonks.org?node_id=1012957


in reply to Re^2: DBD Oracle ORA_XMLTYPE Seg Fault
in thread DBD Oracle ORA_XMLTYPE Seg Fault

Not sure, maybe binding ':out' as a LOB (making sure LongReadLen attribute is sufficiently large)? Or abusing dbms_output to output the value?

Replies are listed 'Best First'.
Re^4: DBD Oracle ORA_XMLTYPE Seg Fault
by grump- (Novice) on Jan 11, 2013 at 20:42 UTC
    I don't believe the 4k limitation is in Perl. Its in the xmltype and/or the getclobval method. Read the last entry here: https://forums.oracle.com/forums/thread.jspa?messageID=1696372 . So I think I need another work around in the query. One that continues to hide the xmltype from the Perl client.