Hi all
I was wondering if some one would be kind enough to help me with an error that I keep getting. I have a stored procedure which doesn't take any parameters. when I try and call it, I get the following error. the funny thing is I have other stored procedure which take parameters which I can all successfully with no problems. It only seems to happen with procedures that do not have any parameters. I have tested the procedure in both SQL plus and Sqldeveloper and it works fine. I am using OC4J 10.1.3.4, Oracle DB 10.2.0.4 eclipselink/toplink as the JPA provider and I am also using the oracle thin drivers i.e. ojdbc14.jar.
Can anyone help please?
Internal Exception: java.sql.SQLException: ORA-00900: invalid SQL statement
Error Code: 900
Call: BEGIN testJPAProc(); END;
Query: DataReadQuery()
Here is the procedure
create or replace procedure testJPAProc is
begin
dbms_output.put_line('testJPAProc called');
end;
Heres is java code for calling the procedure
StoredProcedureCall call = new StoredProcedureCall();
ValueReadQuery query = new ValueReadQuery();
call.setProcedureName("testJPAProc");
query.setCall(call);
session.executeQuery(query);
thanks