Hello. The date field I am trying to filter on stores data in the form:
For some reason, when I execute a stored proc like this:
EXEC procname (to_date('01/03/11','DD-mon-YY'),to_date('31/03/11','DD-mon-YY'))
The stored proc is like this (pseudocode):
create or replace
PROCEDURE procname (From_date IN date, T_date IN date)
CURSOR results_cur IS
O_DATE (From_date,'DD-MON-YY') AND tablename.DATERESOLVED<TO_
The error I get is:
ORA-01843: not a valid month
ORA-06512: at line 1
01843. 00000 - "not a valid month"
Any idea why this would be? The format mask matches the format of the data in the table. So I am at a loss as to why it doesn't see the month is valid. Am I missing something here? Thanks for any guidance.