TOracleObject

[astutus]

Can I use PLSQLTable as a field of TOracleObject

 

[Marco Kalter]

No, this is not possible. You will need to use a collection object (varray or nested table).

 

[astutus]

Have you example for varray

 

[astutus]

I want pass parameter to procedure using TOracleObject
Can i do this for this type ?

Example:

CREATE OR REPLACE TYPE MZ.TTBLVARCHAR AS TABLE OF VARCHAR2(4000);

CREATE OR REPLACE TYPE MZ.OBJ_PARAMETER_ARRAY AS OBJECT (
NAME_PARAMETER VARCHAR2(30),
TYPE_PARAMETER CHAR(2),
VALUE_PARAMETER MZ.TTBLVARCHAR
);

CREATE OR REPLACE TYPE MZ.TBL_PARAMETER_ARRAY AS TABLE OF MZ.OBJ_PARAMETER_ARRAY;

CREATE PROCEDURE F(P MZ.TBL_PARAMETER_ARRAY)
AS
BEGIN

END F;