Re: No documentation exists about ecpg ORACLE comptaible mode

On Tue, Jun  7, 2022 at 08:28:55AM +0000, ideriha.takeshi@fujitsu.com wrote:
> Hi. 
> (CCing Michael Meskes)
> 
> One of my customers asked me about what oracle compatibility mode in ecpg means, 
> and I noticed current documentation does not explain ecpg ORACLE compatible mode  (ecpg -C ORACLE) in detail.
> I myself learned the feature of "-C ORACLE"  from regression test (src/interfaces/ecpg/test/compat_oracle) and source
code.
 
> 
> Is lacking documentation intentional or do commit 3b7ab4380 and 3b9b7516f just forget adding the explanation?
> 
> As for as I know, "ecpg -C ORACLE" is written briefly in ecpg command reference and PostgreSQL 11 release note,
> but they are not enougn information for users to understand feature of "ecpg -C ORACLE".
> 
> https://www.postgresql.org/docs/current/app-ecpg.html
> 
> -------------------------------
> -C mode
> Set a compatibility mode. mode can be INFORMIX, INFORMIX_SE, or ORACLE.
> -------------------------------
> 
> https://www.postgresql.org/docs/11/release-11.html#id-1.11.6.21.5.9
> -------------------------------
> Add an ecpg mode to enable Oracle Pro*C-style handling of char arrays.
> 
> This mode is enabled with -C.
> -------------------------------
> 
> On the other hand, informix compatible mode is written in detail.
> https://www.postgresql.org/docs/current/ecpg-informix-compat.html

This is a very good point.  I have studied the issue and created the
attached patch to document Oracle-compatibility mode.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Indecision is a decision.  Inaction is an action.  Mark Batterson