Devart Forums

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

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