Oracle connection problems fixed!

2002-05-28 Thread Maarten Stolte
Hello, in a sort of reply to my earlier mail, i fixed the public.pm, by loading Apache::DBI instead of DBI, and by reusing the DBH. Thanks goes to Geoff and the rest of #modperl. The code will be released in a very alpha-ish release later this week. Maarten

Oracle connections failing after some time

2002-05-28 Thread Maarten Stolte
Hello, I've spent the last few weeks hacking on DAD, a bannermanagement software for modperl/Mysql, and have mostly converted it to Oracle. This has been quite hard, since the code was very MySQL specific, but I seem to have nearly finished the important parts. There is however some weird probl

help!.... problem with calling procedure..

2001-12-13 Thread Maarten Stolte
$dbh->{LongTruncOk} = 0; my $func; my $receive; my $func = $dbh->prepare(q{ BEGIN xml_mobile.process_xml( p_spr_post => :pgp, p_xml_post => :receive ); END;}); $func->bind_param(':pgp', 'dfdfddf'); $func->bind_param_inout(':receive', \$receive,100); $func->execute; print $receive; Maarten Stolte

problem getting output from Oracle procedure

2001-12-11 Thread Maarten Stolte
Hello, i'm trying to call an oracle procedure from a modperl script, which works somewhat, but I need to get the return value from the procedure. I followed some hints on websites/mailinglists i searched, but i still haven't had any luck in succeeding. This is what I use: my $func = $dbh->prepar