XSD as a Constant Error (ORA-31000)
jaramillOct 20 2008 — edited Oct 24 2008I have the 3 global constants declared in the Package Spec. But when trying to run a query to generate XML Oracle (10g - 10.2.0.4.0) complains with ORA-31000 error. But if I hardcode the XSD it works fine. NameSpace and Instance constants aren't a problem. See example below. The constant in RED is the problem. The value of the constant is similar to this:
SRP_XSD constant varchar2(100) := 'http://www.myexample.com/MyXSD.xsd';
select xmlelement("ProductFeed", xmlattributes(SRP_NAMESPACE as "xmlns:NS2",
SRP_INSTANCE as "xmlns:xsi",
{color:#ff0000}<strong>SRP_XSD</strong>{color} as "xsi:noNamespaceSchemaLocation"
),
Gio