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.