How send array to Oracle Stored Procedure?

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Quido
Posts: 25
Joined: Mon 09 Jan 2006 15:10

How send array to Oracle Stored Procedure?

Post by Quido » Mon 14 Mar 2016 13:04

Hello,

is it possible to send an array as a parametr to Oracle SP from UNIDAC?
Or any other collect data type? Or through TuniTable only?

On Oracle side can be, for example, user defined data type based on TABLE data type:

CREATE OR REPLACE PACKAGE p IS
TYPE p_type IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;

PROCEDURE px (inp p_type);
END p;
/
CREATE OR REPLACE PACKAGE BODY p IS
PROCEDURE px (inp p_type) IS
BEGIN
FOR i IN 1..inp.count LOOP
dbms_output.put_line(inp(i));
END LOOP;
END px;
END p;
/

Thanks in advance

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: How send array to Oracle Stored Procedure?

Post by MaximG » Tue 15 Mar 2016 16:20

Unfortunately, work with Oracle specific objects (REF cursors, Objects, Array) as with parameters is available only in Devart ODAC:

https://www.devart.com/odac/features.html

Post Reply