This week's book giveaway is in the Other Languages forum.
We're giving away four copies of Functional Reactive Programming and have Stephen Blackheath and Anthony Jones on-line!
See this thread for details.
Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

can´t read the Oracle´s XMLTYPE generated in a query in my JSP page

 
antonio alvarez
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, I´ve been working on an application that return an XMLTYPE from an schema package, the XML is generated in a query, not read it in a table, and use that variable in a JSP.

The DDL of the package function is this:



as far as I see there shouldn´t be any problems with this stored function

The problem is on the JSP code

this is my code:



I´m getting te error:

SQL Error: java.sql.SQLException: Inconsistent java and sql object types: SYS.XMLTYPE

Making a debbuging I identified that the exception is been raised in this line:




I´ve been checking a lot of online documentation but I´ve not been able to make it work

If anyone could help me please, I don´t know what else to do

Thanks... sorry for the english
 
Fatih Keles
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can you try this one

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic