Thank you for the response. Can we use the same '$' technique to resolve the parameters which are varying in both sps?
Ashok Madhavan wrote: > > you can use the '$' parameters to send in stuff. Main thing to take into > account for '$' is sql injection. > > call $sp_name$( #bill_id#) > > but then those two remaining two different method makes sense. > > regards > ashok > > On 7/29/07, John Dahl <[EMAIL PROTECTED]> wrote: >> >> >> Ok, here is my requirement. I need to run different sp having different >> parameters. For eg. I need to run following sps >> 1) call generate_bill( #bill_id#) >> 2) call generate_invoice(#invoice_id, #start_date#, #end_date#) >> >> Can I create a single method in sql methods with dynamic tags so that the >> same method can be called to execute any of these sps. sp Name and >> parameter >> map need to be resolved only at run time. Is it possible with iBatis. >> >> Thanx in advance. >> -- >> View this message in context: >> http://www.nabble.com/Running-dynamic-sp-tf4165246.html#a11850587 >> Sent from the iBATIS - User - Java mailing list archive at Nabble.com. >> >> > > -- View this message in context: http://www.nabble.com/Running-dynamic-sp-tf4165246.html#a11859035 Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
