• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to access nested table values?

 
Wei Zhang
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
For example:
CREATE TYPE phonetypes AS TABLE OF VARCHAR2(10);/
CREATE TABLE person (pid VARCHAR2(10),
phone phonetypes);
orquery = "select p.phone "+
"from person p"
OracleXMLQuery oxq = new OracleXMLQuery(
con,orquery);
String result = oxq.getXMLString();
For this or query to access the nested table values, I got exception as follows:
java.lang.NoSuchMethodError
at oracle.xml.sql.dataset.OracleXMLDataSetExtJdbc.getCollectionMetaData(OracleXMLDataSetExtJdbc.java:443)
How to handle this?
Thanks!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic