PROC 12.2 Client Fails With ORA-03108 When Return Using Same Bind (Doc ID 2603570.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

In 12.2 proc client,Whenever the insert/update statement contains returning

clause which uses same bind failed with the below error

ORA-03108: oranet: ORACLE does not support this interface version.

It looked like similar to bug 26203132 but it was for variable and host combination but current bug 29894511 is due to IN and OUT type.

The same code executed successfully in 11.2.0.4 and 12.1.

However, below work around works

1. using different variable works

2. new indicator variable also works

3. compile the code on 12.1 and run on 12.2.

It can be explained with the help of below sample

Upgraded to 12.2.0.1.

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Symptoms

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.