Skip site navigation (1) Skip section navigation (2)

Issues with IN-OUT parameters for Array of Objects in EDB using Java

From: cognizant <sudipbajoria(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Issues with IN-OUT parameters for Array of Objects in EDB using Java
Date: 2012-04-05 14:58:40
Message-ID: 1333637920442-5620617.post@n5.nabble.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi 

I am having issues with passing IN-OUT Parameters from a function which
returns a array of custom defined objects. I know that the new version(8.X+)
of EDB support nested tables and so was wondering this issue must be faced
by other java developers when trying to use the nested tables. Note I tried
types.Other, Array and STRUCT to register the output nested table object but
didnot work.

*Below is my SQL code*

create or replace
TYPE OT_Ref_Country AS OBJECT (
    countryId       		Integer,
    isoFullName     	Varchar2(256),
    doNotUseIndicator    	Integer
);

create or replace
TYPE NT_Ref_Countries IS TABLE OF OT_Ref_Country;

FUNCTION getCountryList ( ip_countryId IN
Ref_Country.countryid%TYPE,iop_NT_Ref_Countries in out NT_Ref_Countries
) RETURN Number ;


*Java code:*

CallableStatement  st = con.prepareCall("{call
pkg_ref_geography_mgr.getCountryList(4,?)}");
st.registerOutParameter(1,Types.OTHER);
st.execute();


Please let me know if any additional details are needed. The version used is
Postgresql 8.4 with Java6

Tks for the help
-Mike

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Issues-with-IN-OUT-parameters-for-Array-of-Objects-in-EDB-using-Java-tp5620617p5620617.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.

Responses

pgsql-jdbc by date

Next:From: Kevin GrittnerDate: 2012-04-05 17:57:40
Subject: Re: Locking
Previous:From: Sez SezDate: 2012-04-05 11:55:51
Subject:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group