oci-21500 internal error code arguments[58]

user1

Member
I am trying to run following querry on plsql developer
select xmlelement( "current_time", sysdate) from dual .

I am getting this error
oci-21500: internal error code, arguments[58],[],[],[],[],[],[],[]
oci-21500: internal error code, arguments[kghfrh:ds],[0x2FB42A4],[],[],[],[],[],[].

I am using OCI version 9.2 with oracle 10g.
Why I am getting this error. how this can be resolved or any other way round to get xml from a query.
 
As a workaround you can use the getclobval() function:

select xmlelement("current_time", sysdate).getclobval() from dual
 
Back
Top