| PASS REFCURSOR TO PL/SQL PROCEDURE [message #143191] |
Wed, 19 October 2005 07:31 |
rtartalia
Messages: 3
Registered: October 2005
|
Junior Member |
|
|
Hi,
My english is bad, i'm sorry.
I need pass an refcursor from Java into a stored procedure PL/SQL. How do this please? I already read articles working with Array and Oracle API specific (ArrayDescriptor, STRUCT, etc), but this not work with me. I get an "invalid name pattern XXXX". I believe that is because no TYPE has created. I was not who I wrote the stored procedures. The code of cursors and procedure signature has below.
PROMPT Creating Package 'AEA0P01'
CREATE OR REPLACE PACKAGE AEA0P01 IS
TYPE REC_T1690 IS RECORD
(COD_REG_APRL NUMBER(6)
,COD_GRUP_SERV NUMBER(2)
,COD_ITEM_SERV NUMBER(2)
,COD_SUB_ITEM_SERV NUMBER(2)
,TXT_DCR_IRRG_OTRO VARCHAR2(254)
,COD_TIP_VIST_APRL VARCHAR2(1)
);
TYPE TPCUR_T1689 IS REF CURSOR RETURN AEA0P01.REC_T1689;
TYPE TPCUR_ITEM_SERV IS REF CURSOR RETURN AEA0P01.REC_ITEM_SERV;
TYPE TPCUR_T1690 IS REF CURSOR RETURN AEA0P01.REC_T1690;
TYPE REC_T1689 IS RECORD
(COD_REG_APRL NUMBER(6)
);
/* .inclusao do cadastro do ria */
PROCEDURE AEA0P01_INS_DADO_RIA
(ECOD_CNCS IN OUT NUMBER
,ECOD_CREA_EMP_CNSV IN OUT NUMBER
,ENOM_RESP_ISPC IN OUT VARCHAR2
,ECOD_CREA_RESP IN OUT NUMBER
,EDT_ISPC IN OUT CHAR
,ECOD_CNPJ_PROP_IMOV IN NUMBER
,ECOD_CPF_PROP_IMOV IN NUMBER
,ECOD_LOG IN NUMBER
,ECOD_IDT_IMOV IN VARCHAR2
,ECOD_IDT_ENDE IN NUMBER
,ECOD_SEQ_PROP IN NUMBER
,ETAB_T1689 IN OUT AEA0P01.TPCUR_T1689
,ETAB_T1690 IN OUT AEA0P01.TPCUR_T1690
,PCOD_REL_ISPC_ANUA IN OUT NUMBER
,PANO_EMIS_REL_ISPC IN OUT NUMBER
,PMENS IN OUT VARCHAR2
);
/
SHOW ERROR
--------------------------------------------------------------------------
END;
--Rafael
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
