RE: stored precedures with array as parameter

2004-06-21 Thread Steve Baldwin
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_

Re: stored precedures with array as parameter

2004-06-21 Thread Hardy Merrill
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

Re: $dbh->last_insert_id() not working

2004-06-21 Thread Tim Bunce
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

Re: $dbh->last_insert_id() not working

2004-06-21 Thread Beau Frusetta
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

stored precedures with array as parameter

2004-06-21 Thread Frank . Motzkat
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