Issue:
SAS script has been failing on connection between SAS and Oracle. A driver update
was performed to fix French accents, but created other issues. When accessing a
Oracle view, I’m getting the error :Error fetching from cursor. ORACLE error is ORA-01843: not a valid month.
Solution:
Check for SAS KB article - 20734: An error occurs when data that has any date format is loaded to Oracle in a non-English environmentIt seems, this error occurs if you load data with date format to Oracle in French environment (non-English).
There is hot-fix available for this issue. The error won't pops-up if hotfix is installed.
Comments
Post a Comment