My Oracle Support Banner

Fetch Of Rowids From A Two Table Join Using Embedded Sql And C (Doc ID 1175933.1)

Last updated on JANUARY 06, 2023

Applies to:

Precompilers - Version to [Release 10.2 to 11.2]
Information in this document applies to any platform.


When performing a FETCH into an ARRAY of ROWIDs from a TWO table join it appears that the ROWID values are not populated into the array properly. Specifically if the results are from a Join of a PARENT and CHILD table where there would be one row for the PARENT table and TWO rows for the CHILD table, the actual ROWID of the PARENT table is only fetched into the first index of the array host variable. The second index of the array variable, which should contain the same value as the first index, is different. If you switch from a FETCH of ROWIDS to a FETCH of identifying columns, using the same FETCH :'x' INTO syntax, the key value for the PARENT table is maintained in all instances of the array.

This is giving  during fetch


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

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