Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

XML extract generating ORA-30625

570384Apr 2 2007 — edited Apr 3 2007
Hello,

Here is a simplified explanation of my problem:

I have xml data stored in a table as a clob.

I am converting this to xmltype using this syntax:
var2 := xmltype(var1);

I am then trying to extract a specific element using this syntax:
var3 := var2.extract('/FIXML/CustDefAcctUpdAttributes/@Account').getstringval();

This then generates the following error:
ORA-30625: method dispatch on NULL SELF argument is disallowed

I have seen explanations of how to get such code to handle null elements.
However, in my case, the element in question is not null.
I wondered if anyone had any thoughts on why I might be getting this error?

Many Thanks,

Matthew
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 1 2007
Added on Apr 2 2007
6 comments
1,706 views