I created resultset in our Oracle. The code segment is given below.
SQL>CREATE OR REPLACE PACKAGE types AS
TYPE Cursortype IS REF CURSOR;
SQL>create or replace procedure sp_stud
open p_cursor for select * from student where readflag = ' ';
Those are created successfully. It contains no errors, compiled & executed successfully at SQL command level.
But, given this SP Name in Sender Side JDBC Adapter - Parameters like below
Query SQL Statement : EXECUTE sp_stud
Update SQL Statement: <test>
After give this parameters, and activate the CC, it shows again the same error.
Database-level error reported by JDBC driver while executing statement 'EXECUTE sp_stud'. The JDBC driver returned the following error message: 'java.sql.SQLException: ORA-00900: invalid SQL statement '. For details, contact your database server vendor.
Friends, still I am not able to solve this problem. Could you kindly try this ? and help me to solve this.
Expecting your reply.