Hi,
Here're my db objects:
CREATE OR REPLACE TYPE tt_dummmy AS OBJECT
(
id NUMBER
)
/
CREATE OR REPLACE TYPE tt_dummmy_arr as table of tt_dummmy
/
CREATE OR REPLACE TYPE tt_dummmy_arr_arr as table of tt_dummmy_arr
/
CREATE OR REPLACE TYPE tt_dummmy_type AS OBJECT
(
dummy NUMBER,
arr tt_dummmy_arr_arr
)
/
CREATE OR REPLACE PACKAGE get_dummy AS
FUNCTION get RETURN tt_dummmy_type;
END;
/
CREATE OR REPLACE PACKAGE BODY get_dummy AS
FUNCTION get RETURN tt_dummmy_type IS
BEGIN
RETURN tt_dummmy_type(dummy => 1, arr => tt_dummmy_arr_arr(tt_dummmy_arr(tt_dummmy(42))));
END;
END;
/
Select works:
SELECT get_dummy.get
FROM dual;
When those objects are converted to Java, I get references to TtDummmyArrConverter, which is not automatically created.
Hi,
Here're my db objects:
CREATE OR REPLACE TYPE tt_dummmy AS OBJECT
(
id NUMBER
)
/
CREATE OR REPLACE TYPE tt_dummmy_arr as table of tt_dummmy
/
CREATE OR REPLACE TYPE tt_dummmy_arr_arr as table of tt_dummmy_arr
/
CREATE OR REPLACE TYPE tt_dummmy_type AS OBJECT
(
dummy NUMBER,
arr tt_dummmy_arr_arr
)
/
CREATE OR REPLACE PACKAGE get_dummy AS
FUNCTION get RETURN tt_dummmy_type;
END;
/
CREATE OR REPLACE PACKAGE BODY get_dummy AS
FUNCTION get RETURN tt_dummmy_type IS
BEGIN
RETURN tt_dummmy_type(dummy => 1, arr => tt_dummmy_arr_arr(tt_dummmy_arr(tt_dummmy(42))));
END;
END;
/
Select works:
SELECT get_dummy.get
FROM dual;
When those objects are converted to Java, I get references to TtDummmyArrConverter, which is not automatically created.