Fetch Of Rowids From A Two Table Join Using Embedded Sql And C (Doc ID 1175933.1)
Last updated on JANUARY 27, 2012
Precompilers - Version: 10.2.0.3 to 22.214.171.124 - Release: 10.2 to 11.2 Information in this document applies to any platform.
***Checked for relevance on 02-May-2011***
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.
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