Oracle ORA-01810, ORA-01812, ORA-01821
From: Joyce <ykyeung7_at_sinagirl.com>
Date: 13 Nov 2001 19:59:54 -0800
Message-ID: <93b5f8b1.0111131959.55b24d4a_at_posting.google.com>
I got the above error when I run my program, which calls a store procedure. I know that all these errors are all related to the date function. In my store procedure, the only part that is related to date is
" WHERE TRUNC(column_name) = TRUNC(sysdate)". Is there anything wrong with this WHERE clause ?
Date: 13 Nov 2001 19:59:54 -0800
Message-ID: <93b5f8b1.0111131959.55b24d4a_at_posting.google.com>
I got the above error when I run my program, which calls a store procedure. I know that all these errors are all related to the date function. In my store procedure, the only part that is related to date is
" WHERE TRUNC(column_name) = TRUNC(sysdate)". Is there anything wrong with this WHERE clause ?
Thanks.
Regards,
Joyce
Received on Wed Nov 14 2001 - 04:59:54 CET