Why can't you bind more than one arg. Show me a code where you try to and
it is failing. bind_param_inout is used if you are expecting values back
from the proc, so you pass it a reference and it will *automagically* update
that scalar with the value.
Ilya
> -----Original Message-----
> From: Rozengurtel, Daniel [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 12, 2001 7:16 PM
> To: [EMAIL PROTECTED]
> Subject: StoreProc
>
>
> 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.
>
