ORA-00600: internal error code, arguments: [opixrb-4], [1036], [ORA-01036: illegal variable name/num

zhulch發表於2007-05-23
..............[@more@]RESEARCH
=========
Bug 4964703 OERI[opixrb-4] [1036] from SELECT over DBLINK with trailing :N or :Q bind names
Fixed-Releases: 9208 A203

.
CAUSE DETERMINATION
====================
OERI[opixrb-4] [1036] from SELECT over DBLINK with trailing :N or :Q bind names


CAUSE JUSTIFICATION
====================
Bug 4964703 OERI[opixrb-4] [1036] from SELECT over DBLINK with trailing :N or :Q bind names

.
PROPOSED SOLUTION(S)
======================
1.Applying patch 4964703
2.Replacing Bind Variable 'n' with another character. (if you use TOAD,this workaround can't
be accepted becuase this variable is defined in TOAD code.)

PROPOSED SOLUTION JUSTIFICATION(S)
====================================
1. Resolve the issue
2. Workaround the issue

.
SOLUTION / ACTION PLAN
=======================
1. Applying Patch 4964703.
--------------------
Description:ORA-600[OPIXRB-4] [1036] WHEN EXECUTING SELECT STMT WITH BIND VARIABLES
Product: RDBMS Server
RELEASE: 10.2.0.2
Platform: AIX5L Based Systems (64-bit)
Last Updated: 09-OCT-2006
Size: 19K (20245 bytes)
--------------------

2.Replacing Bind Variable 'n' with another character.

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7318139/viewspace-915936/,如需轉載,請註明出處,否則將追究法律責任。

相關文章