I have a hierarchical data structure in one of my table called parts.
The structure of the table is something like this
ParentPart, ComponentPart, Data
P7,P8, xyz ……
When I fire a connect by query to traverse the relationship starting with part P1 in sqlplus then I get
However when I fire the same query using OCI APIs and fetch the results using OCIStmtFetch2 API then I get jumbled output. I am getting Row P3,P4, xyz as the first row in the data buffer.
I found that the rows in the data buffer are jumbled and differ from the SQLplus output.
I am using scrollable cursors to fetch the data. And using Oracle 22.214.171.124 database.
My questions are: