You need a NUMBER not a date on that line.

--Payam Moghtader
www.2dev.com



-----Original Message-----
From: Pitoyo
[mailto:oracledba-ezmlmshield-x79684964.[Email address protected]
Sent: Thursday, December 27, 2007 9:32 PM
To: LazyDBA Discussion
Subject: For loop using Date datatype

Hi gurus...
I have a pl/sql block that contains loop. But it doesn't work, it's says
that "wrong of type"
bellow is my code :
for x in sysdate..sysdate + 2 loop -- error in this line
action.......
end loop;

Is it correct that we can't use a date type in loop command ??

Thanks & regards.

Pitoyo



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html


Oracle LazyDBA home page