ORA-01003 no statement parsed

[bhattnirav]

Our application is in Forms 6.0.8.27.

We are using below sql statement in many forms.

select s_erpc_rep_table.nextval into v_seq_no from dual;

From perticular one FORM I am getting ORA-01003 no statement parsed.
This problem comes not on all machines.


Version of FORMS are same at all clients and I have also recompile the FORM.

[bhattnirav]

Problem is solved.

I have given grants.

grant select on S_ERPC_REP_TABLE to public;


My problem is solved but not able to understand if query runs fine at one terminal and not on another. After giving privilege problem is solved.