ORA-01003 no statement parsed
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-01003 no statement parsed

  1. #1
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249

    ORA-01003 no statement parsed

    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.

  2. #2
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width