For loops in model clause

From: GBA-DBA <gba.oraclel_at_gmail.com>
Date: Wed, 25 Jun 2008 13:31:59 -0500
Message-ID: <d7e2170806251131n6f3530a6kc375c82afecfab95@mail.gmail.com>


Hi list,

I'm playing with the model clause but, I'm having some trouble with a rule using a for loop.

dt_elig is a date column in the source table. The error I get is : ORA-32626 Illegal bounds or increment in MODEL FOR loop. Any idea about what I'm doing wrong?

*

FOR* dt_elig *FROM* to_date('01-Dec-07','DD-Mon-YY')
* TO* to_date('01-Jun-08','DD-Mon-YY')
*INCREMENT* numtoyminterval(1,'MONTH')

-- 
Regards
GBA

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 25 2008 - 13:31:59 CDT

Original text of this message