This probably isn't as complicated as it should be, but Business Objects seems to be very, very strict in how types are used versus SQL Developer. Here's the piece of the statement in question:
ship_date between '01' || '-' || w_current_ora_month || '-' || to_char(to_date(w_last_day, 'DD-MON-RR HH:MI:SS AM'), 'yy') and to_char(to_date(w_last_day, 'DD-MON-RR HH:MI:SS AM'))
w_current_ora_month VARCHAR2(3) is filled via:
SELECT to_char(sysdate, 'MON')
INTO w_current_ora_month
FROM dual;
w.last_day DATE is filled via:
SELECT trunc(LAST_DAY('01' || '-' || w_current_ora_month || '-' || to_char(w_year)))
into w_last_day
from dual
Why am I getting a Not Valid Month error when pulling from Business Objects? I've already found the Business objects is way strict on types, so I'm wondering if I'm doing something wrong here. All of this works fine in SQL developer, but I've had to tweak this statement over and over again to try to get it to work when Business Objects uses it.