Issue - call Oracle procedure with custom data type

pulikkottil · **Joined:** Thu Jan 11, 2007 2:49 am **Posts:** 4

Code:

I have a custom date TYPE in Oracle
 
like 
 
CREATE TYPE DATEARRAY AS TABLE OF DATE;
 
it will create TYPE, like date array
 
and I have a Oracle function also
 
like
 
CREATE OR REPLACE FUNCTION doesContain (list DATEARRAY, val VARCHAR2) RETURN NUMBER
IS
....
....
....
END doesContain;

In my Java class,

I have a collection which contain a list of java.util.Date objects 

When I call Oracle function "doesContain", how to pass my java collection to this Oracle function ...

can you provide sample code ?

Thanks,

Pulikkottil

LaLiLuna · **Posted:** Thu Jan 11, 2007 6:23 am

In the Hibernate Wiki is an information using a UserType for this issue. If you are calling the Stored Procedure outside of Hibernate for example using the underlying connection of the session, you can have a look at the Oracle website. They describe how to use User types with JDBC.

pulikkottil · **Joined:** Thu Jan 11, 2007 2:49 am **Posts:** 4

No... we use hibernate call

<sql-query name="getDate" callable="true">
<return class="com.abc.StopResults">
<return-property name="stopDate" column="ST_P_DATE"/>
</return>
{ ? = call (:DATEARRAY, :planid)}
</sql-query>