OCI-21500: internal error code, arguments: [19100], [2],[],[],[],[],[],[]

[FlyingTurtle74]

I am receiving the following error selecting from the customer tables. This error only occurs when I select from hz_locations table.

OCI-21500: internal error code, arguments: [19100], [2],[],[],[],[],[],[]

I am on Version 8.0.0.1480
Oracle 10g db: 10.2.0.4.0

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.

 

[FlyingTurtle74]

Do I add this to the shortcut to start up PL/SQL Developer? The icon on the screen?

 

[FlyingTurtle74]

Interesting... So I added that to the shortcut Icon to PL/SQL Developer and now the query runs. Not sure why but it works... you still want the debug.txt file?

 

[Marco Kalter]

No. Just keep the parameter in place until it fails again. If it continues to work okay, remove the parameter.