Oracle database error code ORA-01819 – signed year precludes use of BC/AD

Oracle Database Error Code ORA-1819 Description :
signed year precludes use of BC/AD
Error Cause:
A date specification contained both a signed year and a B.C./A.D. indicator. If the year is specified with a sign, such as SYYYY, then B.C. or A.D. is implicit in the date and must not be entered.

How to Solve :
Remove the B.C./A.D. indicator from the date specification.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , ,
No Comment Yet   
«
»