March 13, 2009 at 3:48 pm
select *
from table_1
where Trunc(load_date) >= ?
and materialcode in (Select distinct materialcode
from table2
where trunc(load_date) >= ?)
Basically in a nutshell here i am setting a job up in DTS it will pull data from table_1 with material code in table2. The ? for table_1 represents the max date the data is already through. The ? in table2 represents the first day of the month to pull the material codes from. I am continuously getting and ORA - 01843: not a valid month error. If I take out table2 all together everything works fine there seems to be some sort of issue with the variable and table2.
March 18, 2009 at 3:47 am
Sounds like the date formats are incorrect and what the database thinks is the month in the table2 comparison is bigger than 12 so it can't process it. Is the variable in USA format and the database in UK format for example?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply