iBatis sybase stored procedure use return value of one query to another in batch execute sql map

[Kani <mo...@yahoo.com>]

  I need help in mapping the following batch statement in iBatis sql map.

declare @newFuncId    numeric(7,0),
                 @newFailureId numeric(7,0), 
                 @newEffectid  numeric(7,0) ,
                 @newCauseID   numeric(7,0) ,
                @newControlID numeric(7,0) ,
                @newActionID  numeric(7,0) ,
                @newTakenID   numeric(7,0)

exec dallfuncs_sp 2097 4
exec @newFuncId = ufunc_sp 2097, 4, 'T2664KR'0
exec ufndesc_sp @newFuncId 1'rwerw'
exec @newFailureId = ufail_sp 2097, 4, 'T2664KR'0 @newFuncId
exec ufldesc_sp @newFailureId 1,'rwerw'
exec ufailsev_sp @newFailureId null
exec @newEffectid = ueffect_sp 'T2664KR', '', @newFailureId
exec uefdesc_sp @newEffectid @newFailureId ,1,'rwe'
exec @newFuncId = ufunc_sp 2097, 4, 'T2664KR',1
exec ufndesc_sp @newFuncId 1,'rwr'
exec @newFailureId = ufail_sp 2097, 4 ,'T2664KR',0, @newFuncId
exec ufldesc_sp @newFailureId 1,'w'
exec ufailsev_sp @newFailureId null
exec @newEffectid = ueffect_sp 'T2664KR', '', @newFailureId
exec uefdesc_sp @newEffectid @newFailureId, 1,'rwer'

These are the set off statements which is currently working using sybase as
such : Add all the statement to a java.util.Vector and execute using sql
batch execute of the Vector.
. I’am in the process of migrating to the iBatis DAO framework.

I have just started with iBatis. 

Thanks in advace.

-- 
View this message in context: http://www.nabble.com/iBatis-sybase-stored-procedure-use-return-value-of-one-query-to-another-in-batch-execute-sql-map-tf4694738.html#a13419603
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.