Cann't returning 2+ expression when run the same statement by one connection

[Anonymous]

Hi, I found a important problem:

In $OCILIB/demo/ocilib_demo.c, when I add one more 'test_returning' into tab_test[], the demo will 'segmentation fault' for the second call to 'test_returning'.

And, this problem only issues if:
(1) execute one same statement which has returning two or more expression, and
(2) execute it two or more times through the same connection.

My Char-set: all is ANSI,
ORACLE: 10.2
OCILIB: 3.12.1

Tigger Wanc.

[Vincent Rogier]

Hi,

I'll check that point asap.

Regards,

Vincent

[Anonymous]

Hi,

Issue resolved and an fixed in OCI SVN trunk (v4.0.0) at revision 210

Details:

C API : Fixed segfault if a statement was executing more than once SQL statement with a "returning clause" (since statement cache support). It was due to an nice bug in the OCI client !

[Anonymous]

Hi,
Where is the fixed OCI SVN trunk(v4.0.0) at revision 210?

[Vincent Rogier]

fix has been committed into OCILIB SVN trunk repository :

https://sourceforge.net/p/orclib/code/210/

[Anonymous]

Thanks your great works.

The demo 'pool.c' is segfault in this trunk in :
My Char-set: all is ANSI,
ORACLE: 10.2, import mode is LINKAGE.

Thanks again.

[Vincent Rogier]

Fixed the issue that was introduced in recent code refactoring for next V4.0.0.

Fixed at revision 212

Thanks for reporting :)