Does anyone know what causes this error..
PLS-00801: internal error [*** ASSERT at file pdw4.c, line 796;
Cannot coerce between type 49 and type 31;
The statement that caused this error is:
SELECT t.xml.EXTRACT('/ROOT/ROW/PURPOSE/text()') Result INTO i_Purpose FROM (SELECT XMLTYPE( Xml_String) XML From dual) t;
My variable defination is:
Xml_String varchar2(4000):='<ROOT>
<Row>
<Purpose>P1</Purpose>
<SubP>PS1</SubP>
<Analyte>
<ACD1>A1</ACD1>
<ACD2>A2</ACD2>
<ACD3>A3</ACD3>
</Analyte>
<Inum>1625</Inum>
<Lnum>sd7879</Lnum>
<SID>VX2561</SID>
<wrkNum>1234</wrkNum>
<wrkStat>Comp</wrkStat>
<wrsd>20-DEC-2006</wrsd>
<wred>30-MAR-2007</wred>
<AssayNum>1234</AssayNum>
<AssayStat>PEND</AssayStat>
<Instru>5672</Instru>
<AssRDTS>30-JUN-2007</AssRDTS>
<AssRDTE>30-JUN-2007</AssRDTE>
<Dept>234</Dept>
<UserID>JDOW</UserID>
</Row>
</ROOT>';
i_purpose varchar2(15):=Null;
All help is appreciated.
Regards,
Kumar.