I have the following procedure in an Oracle database:
PROCEDURE sp_table_off_t(
p_cod_con IN t411cont.cd_cc%TYPE,
p_cod_loj IN t411loja.cd_loj%TYPE,
p_table_de_par IN T_TODAS_PAR_CAR,
p_tip_cont IN CHAR,
p_codigo_retorno OUT VARCHAR2
);
This procedure has a parameter of type T_TODAS_PAR_CAR
, which is a custom type. The problem is that this type is actually a table:
CREATE OR REPLACE TYPE WEB."T_TODAS_PAR_CAR" IS TABLE OF OBJ_TODAS_PAR_CAR;
And OBJ_TODAS_PAR_CAR
is defined as follows:
CREATE OR REPLACE TYPE WEB."OBJ_TODAS_PAR_CAR" IS OBJECT (
co_car NUMBER(16),
nu_con NUMBER(20),
nu_ad NUMBER(3),
id_crt_cgl VARCHAR2(1)
);
I tried using @Struct
, but I wasn’t successful. Does anyone know how to do this?