For loops in model clause

From: GBA-DBA <>
Date: Wed, 25 Jun 2008 13:31:59 -0500
Message-ID: <>

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')


Received on Wed Jun 25 2008 - 13:31:59 CDT

Original text of this message