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
>