SQL & PL/SQL

Hi Community,

I'm trying to call DBMS_XMLSCHEMA.PURGESCHEMA(schemaid IN RAW), where I extracted the schemaid using
SQL> select SCHEMA_URL,SCHEMA_ID from USER_XML_SCHEMAS;

which outputs 12E33108D03D4E5982CD2D1338AD9A02 as the ID.

SQL> BEGIN DBMS_XMLSCHEMA.purgeSchema('12E33108D03D4E5982CD2D1338AD9A02'); END;

doesn't work (ORA-01948: identifier's name length (2000) exceeds maximum (30)), not does

SQL> BEGIN DBMS_XMLSCHEMA.purgeSchema(RAW('12E33108D03D4E5982CD2D1338AD9A02')); END;

PLS-00222: no function with name 'RAW' exists in this scope

And finally

BEGIN DBMS_XMLSCHEMA.purgeSchema(12E33108D03D4E5982CD2D1338AD9A02); END;

doesn't work either (PLS-00103: Encountered the symbol "03D" when expecting one of the following:).

I'm sure it's a simple type-casting issue, but I can't figure out how to call this method. Can anyone help?

I also tried:

BEGIN DBMS_XMLSCHEMA.purgeSchema(utl_raw.cast_to_raw('3B77542B2E744D6CBCFD2B1B7FF7E02C')); END;

And it still fails with:

ERROR at line 1:
ORA-01948: identifier's name length (2000) exceeds maximum (30)
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 105
ORA-06512: at line 1

Still puzzled...

Thanks, --DD

Message was edited by:
ddevienne