Skip to Content
author's profile photo
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Posted on Aug 21, 2007 at 11:11 AM

    Hi Jhansi,

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

    Regards,

    JaiShankar

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 21, 2007 at 11:18 AM

    Hi,

    Refer this thread...

    JDBC Channel : Connection reset

    Regards,

    vasanth.

    Add comment
    10|10000 characters needed characters exceeded