Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Strange IBatis Exception. Plz Help!!

 
Nitish Shoree
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

Normally when we need to pass user params in a SQL query in iBatis we do it like this...

.....
where empname=#employeeName#

but in my query i have to pass in decode function.. like this...

where empname= Decode(#employeeName1#,'John',#employeeName2#,'Bil l')

but this is throwing exception in my case , is this the way we pass userparams in decode or there is some other way??

Thanks,
Nitish
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic