DBD::Oracle, CLOBs, and segfaults?

jen has asked for the wisdom of the Perl Monks concerning the following question:

I'm having a bit of trouble with DBI and DBD::Oracle.

The following statement causes a segmentation fault:

$sqlInsertXML->bind_param_inout(3, \$result, 300, { ora_type => ORA_CL
+OB });
[download]

I have narrowed it down to the fact that it's a scalar reference and that I'm trying to assign the value ORA_CLOB to ora_type, but after that point, I'm stuck. Can anyone offer some insight?

Thanks,

Jen

Comment on DBD::Oracle, CLOBs, and segfaults? Download Code

Replies are listed 'Best First'.
Re: DBD::Oracle by Anonymous Monk on May 19, 2000 at 08:23 UTC
I have updated/inserted CLOBs sucessfully with this syntax: $sth = $dbh->prepare("update articles set content=? where article_id=?"); # %fdat is a hash set up by Embperl.... $sth->bind_param(1, $fdat{content}, {ora_field=>'content', ora_type=>112}); $sth->bind_param(2, 2442); $sth->execute();	[reply]
Re: DBD::Oracle by jen (Novice) on May 24, 2000 at 21:28 UTC
Apparently, the problem is that I am trying to use CLOB and PL/SQL functions at the same time, and DBD::Oracle doesn't support that. We're trying a workaround instead. Thanks.	[reply]