This is an annoying error that comes and goes during one of your implementation project. The application is using an utility that connecting to database from Excel. The client is version 9.2.0.1 and database is 10.2.0.3
After a quick search on internet,
Metalink note
OCI Application Errors with ORA-3115
Doc ID: Note:460498.1
seems a hit. After I applied the workaround, the problem seems go away for now. The thing I don't like about this is
- It applies not only between 9i and 10g, according to the notes, the problem exists between 10.2.0.3 and 11g as well.
- The workaround is set CURSOR_SHARING to EXACT, which is not preferred setting if you having a lot of customized SQL running on your database.
Looks like Oracle didn't have a patch specifically for this bug yet. If anyone knows otherwise please drop a line.
No comments:
Post a Comment