a bug using type alias??

[Jzhao]

Hi:
I am using type alias , but receiving "ora-04043" error.
here is the code the duplicate the error.

DROP TYPE aaa_t FORCE;

CREATE OR REPLACE TYPE aaa_t AS OBJECT
(
NAME VARCHAR2(30)

-- ##### Type header a_t END ####
) ; -- NOT INSTANTIABLE NOT FINAL;

CREATE OR REPLACE TYPE bbb_t AS OBJECT
(
o aaa_t

-- ##### Type header bbb_t END ####
) ; -- NOT INSTANTIABLE NOT FINAL;

CREATE OR REPLACE TYPE bbb2_t AS OBJECT
(
o aaa_t_alias

-- ##### Type header bbb_t END ####
) ; -- NOT INSTANTIABLE NOT FINAL;

SELECT aaa_t(1) FROM dual
SELECT aaa_t_alias(1) FROM dual
SELECT bbb_t(aaa_t(1)) FROM dual -- this is OK when using original type name
SELECT bbb2_t(aaa_t_alias(1)) FROM dual -- this one does not work when using alias
-- but it works in sqlplus and sqldeveloper
-- get "ora-04043bject aaa_t_alias does not exist error"

 

[Marco Kalter]

Seems like a bug. We'll fix it.

 

[csteinme]

Hello !
We are in the same case, I mean unable to instantiate a table of record or a simple array when calling it through synonym.
Did you fix it ?
Thank you.