Pro*C : Stored procedure in cursor

Hello,

I'm trying to call a stored procedure in a cursor in Pro*C :

EXEC SQL DECLARE cur CURSOR FOR

			SELECT	id
			FROM	suivi_rejet
			WHERE	lib = 'MyLib';
		EXEC SQL OPEN cur;
		EXEC SQL FETCH cur INTO :id;
		
		while (sqlca.sqlcode != NO_DATA_FOUND) 
		{
			EXEC SQL FETCH cur INTO :id;
			EXEC SQL EXECUTE
			BEGIN
				MY_PACKAGE.my_procedure(:id);
			END;
			END-EXEC;
		}
		EXEC SQL CLOSE cur;

by I get : ORA-01002 "fetch out of sequence".

I can't see where is my error. :-(

Thanks in advance for any idea.

-- 
Ce message a ete poste via la plateforme Web club-Internet.fr
This message has been posted by the Web platform club-Internet.fr

http://forums.club-internet.fr/