Hi,
I know how to do it for regulard query statement but I
wasn't sure how to do it with procedures and packages.
I have this procedure. e.g.
I have this procedure
'begin
run_proc ('foo','blah');
end;
'
the procedure will be called either in a perl script.
How would I change it so that it
Consult the Descartes/Bunce Programming the Perl DBI book. See the
section about how to use '?' as a placeholder in your SQL text. You'll
end up with code that looks a little bit like this:
my $sql = begin run_proc(?, ?); end;;
my $sth = $dbh-prepare($sql, {ora_check_sql = 0});
...
# then, inside