Connect By Prior vil ikke executes fra VisualStudio (eller .NET)
Jeg har den er Query som fint virker med SQL Developer...Men jeg kan bare ikke få en OracleCommand til at æde den, bliver ved med at påstå der er invalid characters...
SELECT UNIQUE xt_ref, xt_refid, xt_repid FROM
( 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 = 3172
CONNECT BY PRIOR child_ref = xt_ref;