When I run the following hierarchial query , I receive the following
exception.

Can anyone tell me how to remove this exception and why is it
appearing? Is it some limitation of the Oracle version?

select l.acct_type,l.acct_no,l.create_dt,l.contract_dt
from ln_display_mis l
start with l.acct_type='MTG'
CONNECT BY PRIOR l.create_dt=l.contract_dt;
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to