hi pitoyo:
I think you should not use the date tye in loop command . consider that if you could use the date type ,then what is the granule ? a second , a minute , a hour or a day ?


2007-12-28



Alan Lee(cnoug)

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

Oracle LazyDBA home page