Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting error - ora-01003 no statement parsed

guizani.seifMay 22 2014 — edited May 23 2014

Hi,

Oracle DB 11g.

Forms 6i

procedure test is

cursor c1 is select col1, col2 from my_table1 where col0 = :my_block.col0;

cursor c2 is select col3 from my_table2 ;

cursor c3 is select col4, col5 from my_table2 where col0 = :my_block.col0;

begin

go_block('my_block');

open c2;

LOOP

    FETCH c2

      INTO :my_block.col3;

    EXIT WHEN c2%NOTFOUND;

    next_record;

  END LOOP;

  CLOSE c2;

first_record;

  LOOP

    OPEN c1;

    FETCH c1

      INTO :my_block.col1, :my_block.col2;

    CLOSE c1;

    EXIT WHEN :system.last_record = 'TRUE';

    next_record;

  END LOOP;

first_record;

  LOOP

    OPEN c3;

    FETCH c3

      INTO :my_block.col4, :my_block.col5;

    CLOSE c3;

    EXIT WHEN :system.last_record = 'TRUE';

    next_record;

  END LOOP;

first_record;

EXCEPTION

  WHEN OTHERS THEN

    afficher_exception('test');

END;

This code works correctly almost the time but sometimes an error ora-01003 no statement parsed occurs and my procedure stops working!!!

I've locked in the internet how to resolve it but nothing was adequate with my case!

Any help?

Best regards.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 20 2014
Added on May 22 2014
2 comments
1,896 views