Hi all,
I am trying to pass several values to a store proc, as Ilya sugested
I am using bind_param
however, right i am able to pass only one arg to a proc. Do you
have any idea how to make it happen wtih more than one ?
Thats what I am using:
my $csr = $dbh->prepare(q{
BEGIN
BOXV2.DO_ALL (:instr_id);
END;
});
# The value of $instr_id is _copied_ here
$csr->bind_param(":instr_id", $instr_id);
$csr->execute;
In the perldoc there is something that I cant make sense of.
where do they pass several args at once?:
my $test_num = 5;
my $is_odd;
$csr = $db->prepare(q{
BEGIN
PLSQL_EXAMPLE.PROC_IN_INOUT(:test_num, :is_odd);
END;
});
# The value of $test_num is _copied_ here
$csr->bind_param(":test_num", $test_num);
$csr->bind_param_inout(":is_odd", \$is_odd, 1);
# The execute will automagically update the value of $is_odd
$csr->execute;
print "$test_num is ", ($is_odd) ? "odd - ok" : "even - error!",
"\n";
Can you please suggest on anything?
Thanx a lot,
Daniel
Daniel Rozengurtel
Analyst II -Data Mining/WHSE
IT Clearing-Settlements
Banc of America Securities, LLC
9 West 57th Street, 18th Floor, NYC
Email: [EMAIL PROTECTED]
Phone: (212) 847-6253
_____________________________________________________________________
IMPORTANT NOTICES:
This message is intended only for the addressee. Please notify the
sender by e-mail if you are not the intended recipient. If you are not the
intended recipient, you may not copy, disclose, or distribute this message
or its contents to any other person and any such actions may be unlawful.
Banc of America Securities LLC("BAS") does not accept time
sensitive, action-oriented messages or transaction orders, including orders
to purchase or sell securities, via e-mail.
BAS reserves the right to monitor and review the content of all
messages sent to or from this e-mail address. Messages sent to or from this
e-mail address may be stored on the BAS e-mail system.
