Home » Developer & Programmer » JDeveloper, Java & XML » SQL & xml
SQL & xml [message #638086] Tue, 02 June 2015 02:58 Go to next message
Messages: 98
Registered: October 2014
Hallo all....

I am trying to make a query but i am getting Problem. can anyone please help me?

here is my code:

select T.id
from Table1 T,
xmltable ('/Table1/data'
passing w.metadata
columns name varchar2(50) PATH '/data/name',
status varchar2(50) PATH '/data/status');

and error: ORA:19224:

Thank you.

Re: SQL & xml [message #638088 is a reply to message #638086] Tue, 02 June 2015 03:02 Go to previous message
Michel Cadot
Messages: 67950
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

ORA-19224: XPTY0004 - XQuery static type mismatch: expected - %s got - %s
 *Cause: The expression could not be used because it's static type is not 
         appropriate for the context in which it was used.
 *Action: Fix the expression to be of the required type or add appropriate 
          cast functions around the expression.

You have to post the table description or, better, CREATE TABLE and INSERT statements so that we will be able to repeat what you did along with your SQL*Plus session to know and see what you actually did.

Also, read How to use [code] tags and make your code easier to read.

Previous Topic: Getting ICX_SESSION_FAILED error
Next Topic: Please help with XML parsing
Goto Forum:

Current Time: Sat Sep 25 21:05:06 CDT 2021