Hello,

I am having issue with the below statement in one of my JAVA programs.
What happen is when it try execute stored proc and it bombed(Throws OracleServiceException)display error message Can't access callResolutionReport_SP stored procedure.

Here is section of the code:
result = [b]getHibernateTemplate().findByNamedQueryAndNamedParam(
"Get_Member_SP", memberNames, ReturnValues); .
.
.
catch (DataAccessException e)
{
throw new OracleServiceException("Can't access Get_Member_SP.", e);
}
I have tried objdbc6 and objdbc14 and I still having the issue.
Here are some details:
- src/org/springframework/orm/hibernate3
- ojdbc6
- oracle 11g
- running on Websphere 7.0
- J2EE

Have anyone experienced the issue before and what might cause hibernate could not access stored procedure?

Thank you in advance for your help

PS: I have stack trace file, I wish we have attach file option.