H
Hole
Hi there,
I have a stored procedure returning an Oracle collection (a nested
table of object and not simple arrays).
Do you know how to map it in Java or, preferibally, Hibernate?
The collection type looks like this:
<code>
create or replace TYPE SAMPLED_VALUE AS OBJECT
( data_timestamp date,
data_value number(8,2)
);
create or replace TYPE SAMPLED_VALUES_ARRAY AS TABLE OF SAMPLED_VALUE;
</code>
While the stored procedure is declared as:
<code>
create or replace
PROCEDURE EXTRACTOR_EXTRACT(
id IN NUMBER, dateFrom IN DATE, dateTo IN DATE, step VARCHAR2,
valuesMap OUT NOCOPY SAMPLED_VALUES_ARRAY, error_code OUT NOCOPY
NUMBER, error_description OUT NOCOPY VARCHAR2
) AS
....
....
</code>
Can you suggest me a solution?
Thanks in advance.
I have a stored procedure returning an Oracle collection (a nested
table of object and not simple arrays).
Do you know how to map it in Java or, preferibally, Hibernate?
The collection type looks like this:
<code>
create or replace TYPE SAMPLED_VALUE AS OBJECT
( data_timestamp date,
data_value number(8,2)
);
create or replace TYPE SAMPLED_VALUES_ARRAY AS TABLE OF SAMPLED_VALUE;
</code>
While the stored procedure is declared as:
<code>
create or replace
PROCEDURE EXTRACTOR_EXTRACT(
id IN NUMBER, dateFrom IN DATE, dateTo IN DATE, step VARCHAR2,
valuesMap OUT NOCOPY SAMPLED_VALUES_ARRAY, error_code OUT NOCOPY
NUMBER, error_description OUT NOCOPY VARCHAR2
) AS
....
....
</code>
Can you suggest me a solution?
Thanks in advance.