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.