java.sql.SQLException: ORA-01003: no statement parsed

java.sql.SQLException: ORA-01003: no statement parsed

 

  

Dear friends,
Can somebody tell me what this error means ?

java.sql.SQLException: ORA-01003: no statement parsed

I suspect the following scenario :

I am using a ref cursor.

V_SQL_STATEMENT := 'SELECT EMPNO,ENAME,SAL,COMM FROM EMP';
open cursor for V_SQL_STATEMENT;

I am confused a lot to solve the problem.

COMM is most of the time null.

Is COMM the culprit ?

Do I need to give the values for COMM ?

But it also does not work.

Thanking you,

B.Mani Kumar



Oracle LazyDBA home page