PRO*C bug?

[Quoted] Hello everyone,

 I am running into a weird PRO*C problem. Here's the pseudo code I use:

EXEC SQL DECLARE C_TM_EXTRACT CURSOR FOR SELECT blabla...

EXEC SQL WHENEVER SQLERROR DO sql_error("ORACLE ERROR!");

EXEC SQL CONNECT :user_id IDENTIFIED BY :user_passwd;

EXEC SQL EXECUTE
BEGIN
  tm_utils.create_initial_list(1, 18289, 496181); END;
END-EXEC; EXEC SQL OPEN C_TM_EXTRACT;
(*1) EXEC SQL WHENEVER NOT FOUND DO break;
for (;;)
{

   EXEC SQL FETCH C_TM_EXTRACT INTO :blablabla }

EXEC SQL CLOSE C_TM_EXTRACT;
(*2) EXEC SQL EXECUTE

 BEGIN
   tm_utils.create_initial_list(1, 18289, 496182);  END;
END-EXEC; [Quoted]  This last EXEC SQL EXECUTE block (*2) will not compile once I get to the C compiler. The PRO*C compiler can do its business just fine but I can't get it to compile using Sun's C compiler. It will complain and tell me that it found "break outside loop or switch".

 This is all right if I remove line (*1), it will compile in both PRO*C and regular C.

 Any help is appreciated.
 Regards,
 P Received on Fri Nov 13 1998 - 00:00:00 CET