You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by wilberto <wi...@ec-red.com> on 2005/07/26 18:18:29 UTC

InOut param problem with oracle

I have this insert procedure with subtypes: 

PROCEDURE SAV(
	P_per_nid_Persona 	INOUT ST_per_nid_Persona,
	P_per_nid_Nacionalidad  IN    ST_per_nid_Nacionalidad, 

.... more fields... 

	P_IndicadorInfractor    IN    ST_IndicadorInfractor,
       P_TIP_OPE     		IN    VARCHAR2,
       R_RESULT      		OUT   refcur_type); 

Inside the procedure get a secuence to P_per_nid_Persona (Integer) and retur 
the value to java, but in practice no error was found and no value for 
P_per_nid_Persona (R_RESULT cursor is fine) . How i can solve this problem? 

Thank You. 

Wilberto 


---------------------------------------------------------------
EC Red Internet gr@tis
Inscríbete en www.ec-red.com

Re: InOut param problem with oracle

Posted by Daniel Henrique Ferreira e Silva <dh...@gmail.com>.
Hi Wilberto,

It seems that you are not using only primitive types on your stored
procedure, so i think it'd be necessary to use Custom Type Handlers.
Guess this wiki note may help you in some way:

http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+use+a+Custom+Type+Handler+with+complex+property+or+Type+Safe+Enumeration

Cheers,
Daniel Silva.

On 7/26/05, wilberto <wi...@ec-red.com> wrote:
> I have this insert procedure with subtypes:
> 
> PROCEDURE SAV(
>         P_per_nid_Persona       INOUT ST_per_nid_Persona,
>         P_per_nid_Nacionalidad  IN    ST_per_nid_Nacionalidad,
> 
> .... more fields...
> 
>         P_IndicadorInfractor    IN    ST_IndicadorInfractor,
>        P_TIP_OPE                IN    VARCHAR2,
>        R_RESULT                 OUT   refcur_type);
> 
> Inside the procedure get a secuence to P_per_nid_Persona (Integer) and retur
> the value to java, but in practice no error was found and no value for
> P_per_nid_Persona (R_RESULT cursor is fine) . How i can solve this problem?
> 
> Thank You.
> 
> Wilberto
> 
> 
> ---------------------------------------------------------------
> EC Red Internet gr@tis
> Inscríbete en www.ec-red.com
>