-
hi everybody,
I get
ORA-00600: internal error code, arguments: [17182], [211804268], [], [], [],[], [], []
whenever i do
SELECT TO_CHAR(sysdate,'mm/dd/yyyy') FROM DUAL;
In init.ora i have set
CURSOR_SHARING = FORCE .
when i remove this line from init.ora i do not get the error.
can anyone tell why is this error coming?
Amar Subba
-
What is your database version? What is the OS?
You may be hitting the BUG#1365873.
Sam
Thanx
Sam
Life is a journey, not a destination!
-
I am using Oracle 8.1.7 with Windows NT(Workstaion) SP6.
Thanks and Regards
Amar Subba
-
This could be due to some memory corruption on the server. Interms of oracle it was a heap corruption. Run a memory check on the server. If you find it all to be in a good shape, try applying the Oracle patchset. Though it was said that oracle 8.1.7.2.6 fixed
"Bug:1752554
RDBMS: ORA-600 [17182] When selecting DB2 data type of CHAR in a JAVA application "
I don't know how much this would apply to your problem. So try applying the latest patchset for Oracle and then monitor to see whether this problem still exists and if it were to exists still then contact oracle.
Sam
Thanx
Sam
Life is a journey, not a destination!
-
hi sam,
I applied Patch 8.1.7.1.5 and that did the magic, now I can run all queries with to_char conversion.
Thanks a lot
Amar Subba
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|