Hi
I am on Oracle 11.2.0.3
[code]
drop table test ;
create table test of xmltype;
insert into test
values('
<Employee
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="">
<location>
<joiningDate id = "onsite" >
<hireDate>2012-06-18</hireDate>
</joiningDate>
<joiningDate id = "offshore">
<hireDate>2011-07-8</hireDate>
</joiningDate>
</location>
</Employee>');
commit;
exec DBMS_XMLINDEX.dropParameter('myprop');
CREATE INDEX test_xml_index ON test (OBJECT_VALUE)
INDEXTYPE IS XDB.XMLIndex PARAMETERS ('PATH TABLE test_dates_tab');
BEGIN
DBMS_XMLINDEX.registerParameter(
'myprop',
'ADD_GROUP GROUP test_dates
XMLTable test_dates_tab ''/Employee''
XMLNAMESPACES (''http://www.w3.org/2001/XMLSchema-instance'' AS "xsi")
COLUMNS onsite date PATH ''.//*[@id="onsite"]/hireDate/text()''
');
END;
/
ALTER INDEX test_xml_index PARAMETERS('PARAM myprop');
[/code]
when i execute the alter index below i get the error.
I am following the documentation at Indexing XMLType Data example 6-20
[code]
SQL> ALTER INDEX test_xml_index PARAMETERS('PARAM myprop');
ALTER INDEX test_xml_index PARAMETERS('PARAM myprop')
*
ERROR at line 1:
ORA-29874: warning in the execution of ODCIINDEXALTER routine
[/code]
ORA-29960: line 1, ORA-02000: missing keyword