Antwort: Re: stored precedures with array as parameter

From: Frank Motzkat (Frank.Motzkat_at_ic3s.de)
Date: 06/22/04 

To: "Hardy Merrill" <HMerrill@dhcr.state.ny.us>
Date: Tue, 22 Jun 2004 07:47:22 +0200

my problem is not the stored procedure call but the handling of the Oracle
type definition in perl.

TYPE my_tagnames IS TABLE OF varchar2(200) INDEX BY BINARY_INTEGER;

It's not clear to me how or even if I can call a stored procedure with
such input values.

Thanks for any help in advance !!!

regards,

frank

"Hardy Merrill" <HMerrill@dhcr.state.ny.us>
21.06.2004 19:28

An
<Frank.Motzkat@ic3s.de>, <dbi-users@perl.org>
Kopie

Thema
Re: stored precedures with array as parameter

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.

>>> <Frank.Motzkat@ic3s.de> 06/21/04 11:11AM >>>
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 PACKAGE mystorage IS
  TYPE my_tagnames IS TABLE OF varchar2(200) INDEX BY BINARY_INTEGER;

FUNCTION insert_sm (msgid IN varchar2,
                        tagnames IN my_tagnames,
                        tagvalues IN my_tagnames,
                        sf_info OUT VARCHAR2
                       ) RETURN NUMBER;

 
END mystorage;
/

How should the prepare statement look like and how can I forward the
array's to the function ?

Thank for any help in advance !

kind regards,

frank

Relevant Pages

  • Re: rpgle, pcml & arrays
    ... allocation. ... If the program allocates memory on demand to store the array, ... SQL provides a way for a stored procedure to return a result set. ...
    (comp.sys.ibm.as400.misc)
  • Re: Passing arrays to a stored procedure
    ... sql developers around the world and Joe your attitude was quite frankly rude ... I am also writing a stored procedure and have to put an array of values into ... > into scalars. ...
    (microsoft.public.sqlserver.programming)
  • Re: rpgle, pcml & arrays
    ... can construct result set from a query or from an array. ... look at the SET RESULT SETS FOR CURSOR statement. ... SQL or in a store procedure in SQL stored procedure statements. ... doesn't support dynamic lenght parameters in the invoked ile code. ...
    (comp.sys.ibm.as400.misc)
  • Re: Stored procedure to set defaults
    ... AFields() will give you an array of field names, types, etc. ... >I dont know the basis of stored procedure.. ... > "Dan Freeman" wrote in message ...
    (microsoft.public.fox.vfp.dbc)
  • Passing VARBINARY/BINARY param to a stored proc
    ... VARBINARY parameter in an SQL Server 2000 stored procedure. ... Value is an array. ... Dim Proc As Command ...
    (microsoft.public.data.ado)