Thanks Paul,

But still problem presists, as the table column for month and year are of type numbers..

ORA-01843: not a valid month is coming.

How to cast this here.