'java.sql.SQLException: ORA-00900: invalid SQL statement

[Former Member]

Hi friends,

I created resultset in our Oracle. The code segment is given below.

-

---

SQL>CREATE OR REPLACE PACKAGE types AS

TYPE Cursortype IS REF CURSOR;

END;

SQL>create or replace procedure sp_stud

as

p_cursor types.Cursortype;

begin

open p_cursor for select * from student where readflag = ' ';

end;

-

---

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.

comes

-

---

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.

Regards,

jhansi

[Former Member]

Hi,

Refer this thread...

Regards,

vasanth.

[Former Member]

Hi Jhansi,

Have a look into the previous thread, where u described your issue.

Regards,

JaiShankar