Now i got a different error, seems be better. DBD::Oracle::st execute failed: (DBD ERROR: LOB refetch attempted for unsupported statement type) [for Statement "BEGIN get_custumer_info(?, ?); END;" with ParamValues: :p1=1, :p2=''] at clob.pl line 23.
Thanks for the tip Ronald. "Ronald J Kimball" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Tue, Dec 09, 2003 at 09:29:39PM -0800, Odilon Oliveira [ builder ] wrote: > > Execution: > > > > dbdev:/cgi/pl # perl clob.pl > > Segmentation fault > > I've had DBD::Oracle segfault when I try to bind undef to a CLOB. I don't > know if this will work for you, but try setting $vreturn to the empty > string before you call bind_param_inout(). > > Ronald > > > > > > > # local variables > > > > > $id = 1; > > > > > my $vreturn; > > > > > > > > > > $stmt = $dbh->prepare("BEGIN get_custumer_info(?, ?); END;"); > > > > > $stmt->bind_param(1, $id); > > > > > $stmt->bind_param_inout(2, \$vreturn, {ora_type => ORA_CLOB});
