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. > >
