ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Dahl <clickjohnd...@gmail.com>
Subject Re: Running dynamic sp
Date Mon, 30 Jul 2007 07:07:27 GMT

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 <clickjohndahl@gmail.com> 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.


Mime
View raw message