Fetch Of Rowids From A Two Table Join Using Embedded Sql And C
(Doc ID 1175933.1)
Last updated on JANUARY 06, 2020
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!