ECOB compatibility with Pro*C

Compatibility

OceanBase Embedded SQL in C (ECOB) V1.1.0 does not support the following features of PRO*C:

1. ECOB does not completely support the preprocessor macro #elif in C language when PARSE is set to FULL.

2. ECOB does not support the value YES for THREADS or the corresponding multi-thread secure runtime.

3. ECOB does not support Dynamic SQL Method 4 of Oracle or the related SQL descriptor area (SQLDA) data structure.

4. ECOB does not support executing the PL anonymous block by using the EXECUTE ... END-EXEC cluse.

Migration instructions

To replace the Oracle PROC precompiler program with the OceanBase ecob precompiler program to compile the source files, you only need to slightly adjust the code.

At present, ECOB does not support the C preprocessor command #elif. When an error is returned, perform the following troubleshooting steps:

1. If #elif appears in the .h header file, replace h with #include <>.

2. If #elif appears in the .pc file, you can: a. Set parse_cpp_directive to no. b. Remove #elif.

   ECOB does not support Dynamic SQL Method 4 of Oracle or the related SQLDA data structure. If this feature is required, change to the DESCRIPTOR based dynamic SQL statements of ANSI.