My version of oracle is Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
When i perform stored function call using xml table i get that error above.
I am calling the function in my java application, jdk 1.5 >> oracle driver class is in the jar ojdbc14, this jar file i downloaded from the oracle website.
i ran the select statement select * from all_registry_banners; and it looks like there is a JVM and xml database version. Is it a problem due to the fact i am using a CLOB as a parameter?
The funny thing is that if i use a later version for oracle class driver ojdbc14-10.2.0.2 downloaded from findjar.com i get a different error:
Haha, thanks for the reply Satya. You try and keep things compatiable as in use the correct driver with your version of software and it does not work, but when you use a later version it does!! The later version actually gives me a different error but i know why, its due to setting a string in my callable statement, when it should be a CLOB.
So just have to look into how to set a clob in jdbc for a string!
subject: Error java.sql.SQLException: Bigger type length than Maximum