( SELECT XTR.REFER as xt_ref, XTR.XTID as xt_id, XTO.XNAME as xt_refid, XTO.REPOSIT as xt_repid, XTH.PARRENT as parrent, XTH.CHILDREFER as child_ref FROM XReferences XTR INNER JOIN XTable XTO ON XTO.XTID = XTR.XTID LEFT OUTER JOIN XTree XTH ON XTR.XTID = XTH.PARRENT )
START WITH xt_ref = :INPUT_REFER CONNECT BY PRIOR child_ref = xt_ref;
Which is used to get a flat view of a hierarchical structure where all childs are uniqely represented (if the exists several places in the structure thats filtered out...
The Query has been tested in Oracle SQL Developer where it works as expected.
When i den try to use the OracleClient -> OracleCommand (System.Data.OracleClient.OracleCommand)
I Keep getting an ORA-00911: Invalid character
And since its working in the Oracle SQL Developer, and that "Connect by prior" should be valid SQL for Oracle as well... im having a hard time to find out whats the actual problem is... can it be that the OracleClient in some way does not support the above?... and in that case how?... i mean its SQL it just has to pass on to Oracle...