[HACKERS] ECPG: WHENEVER statement with DO CONTINUE action

[vinayak]

Hello,

To develop the ECPG application more efficiently and improve portability,

Oracle Pro*C supports WHENEVER statement with DO CONTINUE action.[1]

EXEC SQL WHENEVER SQLERROR CONTINUE;
is not same as
EXEC SQL WHENEVER SQLERROR DO CONTINUE;



I have tried to implement it. Please check the attached patch.

Please give me feedback.


[1]https://docs.oracle.com/cd/B28359_01/appdev.111/b28427/pc_09err.htm#i12340


Regards,

Vinayak Pokale
NTT Open Source Software Center

I would like to suggest one minor improvement "WHENEVER condition *DO CONTINUE*" support in ECPG. The CONTINUE action instructs the client application to proceed to the next statement whereas DO CONTINUE action instructs the client application to emit a C continue statement and the flow of control return to the beginning of the enclosing loop.

whenever-do-continue.patch
Description: binary/octet-stream

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers