ECPG: WHENEVER statement with DO CONTINUE action

vinayak <pokale_vinayak_q3@lab.ntt.co.jp>

From: vinayak <Pokale_Vinayak_q3@lab.ntt.co.jp>
To: pgsql-hackers <pgsql-hackers@postgresql.org>
Cc: meskes@postgresql.org
Date: 2017-06-09T08:01:36Z
Lists: pgsql-hackers

Attachments

Hello,

To develop the ECPG application more efficiently and improve portability,
I would like to suggest one minor improvement "WHENEVER condition *DO 
CONTINUE*" support in ECPG.
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;

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.

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

Commits

  1. Fix locale dependency in new ecpg test case.