Friday, July 18, 2008

DBMS_XMLSCHEMA.generateschema gives ORA-22303: type not found

I just had someone call about this.
SELECT DBMS_XMLSCHEMA.generateschema('your_schema','your_type') FROM DUAL;
gives ORA-22303: type "your_schema"."your_type" not found
ora-21700
ora-06512

Just upper case your_schema and your_type -- YOUR_SCHEMA and YOUR_TYPE.

Hope this helps.

3 comments:

Anonymous said...

Thanks...
It worked well for me..

Tony said...

changed the case still have the same error code. I can do a desc on it and see the Schema name and table name! Driving me nuts!

Tony said...

Don't worry about me previous post - fixed it.