I'm not sure what's puzzling you. There are two types of bind variables
(also known as placeholders): IN and INOUT. The second example you give in
your message has one of each type of bind variable. If you want more of
either or both types, just define them the same way.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
----- Original Message -----
From: "Rozengurtel, Daniel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 12, 2001 16:16
Subject: StoreProc
> 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?
