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

Last updated on JANUARY 27, 2012

Applies to:

Precompilers - Version: 10.2.0.3 to 11.2.0.1 - Release: 10.2 to 11.2
Information in this document applies to any platform.
***Checked for relevance on 02-May-2011***

Symptoms

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

ORA-100: no data found.

or for non-ANSI

ORA-1403: no data found.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms