Hi All,

I have a procedure in Oracle with the following statement:

PROCEDURE PROC_VDN2501
( P_IC_DEVOLUCAO IN VARCHAR2
,P_DT_INCLUSAO_RM_INICIO IN DATE
,P_DT_INCLUSAO_RM_FIM IN DATE
,P_TYPE IN OUT NOCOPY TAB_REQR
,P_CD_SISTEMA OUT NOCOPY VARCHAR2
,P_CD_PROCESSO OUT NOCOPY NUMBER
,P_CD_RETORNO OUT NOCOPY NUMBER
,P_DS_MENSAGEM OUT NOCOPY VARCHAR2
);

The fourth parameter reported was declared in the same package as below:

TYPE TAB_REQR IS TABLE OF TYPVDN_REC_REQR INDEX BY BINARY_INTEGER;

If you look it has a specific type in which it was held also in the same package, as follows:

TYPE TYPVDN_REC_REQR IS RECORD
( ID_EMPRESA REQUISICAO_MATERIAL.ID_EMPRESA%TYPE
,ID_FILIAL REQUISICAO_MATERIAL.ID_FILIAL%TYPE
,IC_FATURA REQUISICAO_MATERIAL.IC_FATURA%TYPE
,NU_PED_CLI REQUISICAO_MATERIAL.NU_PED_CLI%TYPE
,IT_PED_CLI REQUISICAO_MATERIAL.IT_PED_CLI%TYPE );

I wish somebody would help me showing me how do i call the procedure through hibernate using this parameter.

Thank you all.

Hi dfsilva, All,

I have kind of similar question:
viewtopic.php?f=1&t=1001289

All suggestions or working good examples are welcome.

Thanks in advance,

Tuno