OK,
now I'm ready to answer my question om my own.
The point was exactly that. DBI::Proxy worked well only for 'numbered'
parameters. I've created small and dirty patch to work with named parameters
as well. Who is the right person to talk about the patch for DBI::Proxy?
Reg's
Oleg
> -----Original Message-----
> From: Oleg Mechtcheriakov [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 20, 2001 12:35 PM
> To: [EMAIL PROTECTED]
> Subject: DBD::Proxy and bind_param (with ORACLE)
>
>
> Greetings,
>
> has someone experienced troubles with DBD::Proxy and
> bind_param function?
>
> I'm trying to switch from DBD::Oracle to DBD::Proxy and
> everything was OK
> but bind_param gives me an exception.
>
> Here is the code snippet:
>
> my $addr_id;
> my $sth = $dbh->prepare(q{BEGIN :id :=
> first_req.check_req_sub_ok(:address);END;});
> $sth->bind_param_inout(":id",\$addr_id,32,DBI::SQL_INTEGER);
> $sth->bind_param(":address",$address);
>
> which gives me the following error message at the first
> bind_param_inout
>
> Modification of non-creatable array value attempted, subscript -1 at
> /usr/local/lib/perl5/site_perl/5.6.1/i86pc-solaris/DBD/Proxy.p
> m line 536
>
> Any ideas?
>
> Many thanks in advance
> Oleg
>
>