"Invalid SQL statement" when invoking StoredProcedureCall
623701Oct 8 2008 — edited Oct 9 2008
I'm developing an application using TopLink 11g (with JDeveloper 11g). I created a method to execute a StoredProcedureCall (that is inside a package) and it works in TP1, TP2, TP3 and TP4 but now, with the release of JDeveloper 11g, it doesn't work and throws this exception:
java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement
I follow the documentation to do this method:
I try by using 'executeNonSelectingCall' / 'executeSelectingCall' directly and by using 'ValueReadQuery' / 'DataModifyQuery' setting the call of the query. But still the same.
I know it's a strange case, but real. So, any ideas? Is there, perhaps, an additional toplink configuration for acces to stored procedure calls?
Thanks in advance,