![Question :?:](./images/smilies/icon_question.gif)
![Question :?:](./images/smilies/icon_question.gif)
i have designed a job to insert a data into a table:
the problem that i face is that it displaying error "non- numeric found where numeric expected".. i m stucked up there...
even the i have to set the date column as varchar else it is displaying error..
i have column types as decimal and varchar(including 2 column which shoud be date but..)...
i have used nvl to set date 31-dec-9999 where ever it encounters null.
not a single column is inserted and all the error are same that i have mentioned.
why DS is not taking date as date?
why i have to delclare it varchar?
![Sad :(](./images/smilies/icon_sad.gif)
please anybody help me in this context