Re: Calling oracle procedure from Java using iBatis

2009-08-26 Thread Anta
Thanks for Reply.. After a hour of debugging I resolved the issue by removing the "parameterClass" attribute from the procedure element in sqlmap. Then it works fine. Once again thanks for your replies Regards, Ant Anta wrote: > > > Hi All, > > I have a stored procedure as like below in or

Re: Calling oracle procedure from Java using iBatis

2009-08-26 Thread Ellis Miller
Or pass/create procedure with out parameter and could test returning "constant" to determine if missing return value is related to error. Otherwise, use a Function as function requires return value and, again, could simplify the testing regarding the prior post. On Aug 26, 2009 3:28 PM, "Dan Turke

Re: Calling oracle procedure from Java using iBatis

2009-08-26 Thread Dan Turkenkopf
Hi Ant, I'm not tremendously familiar with PL/SQL stored procedures, but it doesn't look like you're returning anything from yours. I think what's happening is the queryForObject method is looking for a return parameter and not finding anything. If the procedure really doesn't need to return any