Home » SQL & PL/SQL » SQL & PL/SQL » OCI-21500: internal error code (Oracle 9i release 9.2.0.7.0)
OCI-21500: internal error code [message #355213] Thu, 23 October 2008 02:44 Go to next message
rohitupgzp
Messages: 11
Registered: August 2008
Junior Member
Hi, I am using the below script

create table xml_element_test (
some_id number primary key,
some_col_1 varchar2(10),
some_col_2 date,
some_col_3 number(5)
);
alter session set nls_date_format='dd-mon-yyyy';

insert into xml_element_test values( 1, 'one' , '15-jan-1974', 74);
insert into xml_element_test values( 2, 'two' , '28-mar-1891', 18);
insert into xml_element_test values( 3, 'three', ' 7-sep-1599', 59);
insert into xml_element_test values( 4, 'four' , '10-aug-1616', 16);
insert into xml_element_test values( 5, 'five' , '19-oct-1904', 19);

and I want the xml out put for the query

select XMLElement ("SomeElementName", some_col_1) from xml_element_test x;


All I get is an error alert on pl/sql developer
OCI-21500: internal error code, arguments [19100],[2],[],[],[]

The versions I am using is
Oracle 9i release 9.2.0.7.0
pl/sql developer :7.1.5.1.1398
Re: OCI-21500: internal error code [message #355218 is a reply to message #355213] Thu, 23 October 2008 03:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OCI-21500: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]
 *Cause:  This is the generic error number for the OCI
          environment (client-side) internal errors.  This indicates
          that the OCI environment has encountered an exceptional
          condition.
 *Action: Report as a bug - the first argument is the internal error number.

Regards
Michel
Re: OCI-21500: internal error code [message #355222 is a reply to message #355213] Thu, 23 October 2008 03:17 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It works with SQL*Plus, so it is a PLSQL Developer or OCI client problem (what is the version of this later?).

Regards
Michel
Previous Topic: can we use explicit cursor as out parameter for procedure
Next Topic: looking for records with newest dates (merged)
Goto Forum:
  


Current Time: Fri Dec 09 17:24:00 CST 2016

Total time taken to generate the page: 0.39450 seconds