Skip to Main Content

"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,

Post Details
Added on Oct 8 2008
1 comment