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 -~----------~----~----~----~------~----~------~--~---