PL/SQL Tables (arrays) are not supported by DBD::Oracle. In this particular
situation, one solution may be to do something like this :
CREATE OR REPLACE PACKAGE mystorage IS
TYPE my_tagnames IS TABLE OF varchar2(200) INDEX BY BINARY_INTEGER;
prmTagNames my_tagnames ;
prmTagValues my_
Have you read the DBD::Oracle perldocs? I haven't done that myself, but
I'm almost certain the DBD::Oracle perldocs describe how to invoke a
stored procedure.
>>> <[EMAIL PROTECTED]> 06/21/04 11:11AM >>>
Hi all,
I'm looking for a way to call stored precedures directly with one or
more
arrays as
On Thu, Jun 17, 2004 at 12:06:29PM +1000, Daniel Kasak wrote:
> Hi all.
>
> I'm using DBI-1.42, Perl-5.8.4, MySQL-4.0.18 and DBD::MySQL-2.9003.
> I'm trying to get the ID of the last inserted record.
>
> I can use:
>
> >$dbh->{'mysql_insertid'}
>
> and it returns the correct value, however if I
I'm having a similar problem...anyone have a resolution?
--
Thanks,
Beau Frusetta ([EMAIL PROTECTED])
"Daniel Kasak" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi all.
>
> I'm using DBI-1.42, Perl-5.8.4, MySQL-4.0.18 and DBD::MySQL-2.9003.
> I'm trying to get the ID of the last
Hi all,
I'm looking for a way to call stored precedures directly with one or more
arrays as input parameter via DBD:Oracle interface.
Does anybody has a hint for me how I can do this ?
Let me say that the function that I would like to call looks similar to
the one below:
CREATE OR REPLACE PAC