SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Missing Identifier Error.Please help.

432292Mar 21 2007 — edited Mar 21 2007

I am using the flwg code and am getting the error:

09:53:29 ORA-00931: missing identifier

SELECT XMLELEMENT("Items", XMLATTRIBUTES('Value' as "xmlns:tables"), 
       XMLELEMENT("Item",  XMLATTRIBUTES(x.code as "code",x.desc as "desc"))
       FROM (SELECT distinct xml.extract(a.xml, 'tables:code/text()', 
                             xml.getns('NS_TABLES')) as extractedcode,
                             xml.extract(a.xml, 'tables:description/text()', xml.getns('NS_TABLES')) as edescription
             FROM  MyTable a
             WHERE a.ACTIVE='Y')x

Can anyone please tell what identfier am i missing?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 18 2007

Added on Mar 21 2007

4 comments

3,026 views