Skip to Main Content

"Invalid SQL statement" when invoking StoredProcedureCall

623701Oct 8 2008 — edited Oct 9 2008
Hello,

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:

[http://download.oracle.com/docs/cd/E12839_01/web.1111/b32441/qrybas.htm#CIHDEFEE|http://download.oracle.com/docs/cd/E12839_01/web.1111/b32441/qrybas.htm#CIHDEFEE]

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,

JVN
Comments
Post Details
Added on Oct 8 2008
1 comment
431 views