Error java.sql.SQLException: Bigger type length than Maximum

[Shane Lee]

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:

PLS-00201: identifier 'SYS.DBMS_XQUERYINT' must be declared

I am really lost, please help!

Regards,
Shane.

my java code is:

String query = oracleQuery;
CallableStatement stmt = conn.prepareCall(query);

// register the type of the out param - an Oracle specific type
stmt.registerOutParameter(1, OracleTypes.CURSOR);

// set the in param
String xml = readInAsFile();
stmt.setString(2, xml );

// execute and retrieve the result set
stmt.execute();
ResultSet rs = (ResultSet)stmt.getObject(1);

stored function is:

CREATE OR REPLACE FUNCTION JL_INTERFACE.MAPPING_ITEMS_FUNC (xmlInput IN CLOB) 
RETURN SYS_REFCURSOR
Is
mappingItemsCursor SYS_REFCURSOR;


Begin
Open mappingItemsCursor FOR 
Select Identifiers., orders., OTCC.OTCC, OTCC.OTCC_DIC 
From (Select XMLType(xmlInput) as xmlMessage
From Dual) xmlTypeInput


,XMLTable('for $i in /Message
return $i'
Passing xmlTypeInput.xmlMessage 
Columns Jurisdiction VARCHAR(50) Path 'Body/Outcome/OutcomeHeader/CourtAppearance/Court/@Jurisdiction', 
Law_Part_Code VARCHAR(50) Path 'Body/Outcome/Offence/ActionIdentifiers/@LawPartCode',
HNumber VARCHAR(50) Path 'Body/Outcome/Offence/ActionIdentifiers/ActionID/CANReference/@HNumber' 
) Identifiers


,XMLTable('for $i in /Message/Body/Outcome/Offence/Order
return $i'
Passing xmlTypeInput.xmlMessage 
Columns Order_Number VARCHAR(50) Path '@JusticelinkOrderNumber' ,
Order_Category VARCHAR(50) Path 'OrderTypeCodes/@JusticelinkOrderCategory' , 
Order_Type VARCHAR(50) Path 'OrderTypeCodes/@JusticelinkOrderType',
Next_Hearing_Type VARCHAR(50) Path 'NewListingDetails/Listing/ListingDetail/NextHearingType' 
) Orders


,JL_INTERFACE.ORDER_TYPE_NSWP_OTCC OTCC


Where OTCC.Jurisdiction = Identifiers.Jurisdiction
And OTCC.Order_Type = Orders.Order_Type
And OTCC.Next_Hearing_Type = Orders.Next_Hearing_Type ; 

Return mappingItemsCursor;
End MAPPING_ITEMS_FUNC;

[Satya Maheshwari]

This seems to be bug with the driver class. Maybe you could go through : http://www.orafaq.com/forum/t/34666/0/

[Shane Lee]

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!

Regards,
Shane.