Yes, I found I can get data type if I create it in Oracle:
Create VARCHAR2_I_TABLE IS TABLE OF VARCHAR2(300)
But If I only defined this type in a package:
CREATE OR REPLACE PACKAGE PKG_BULK_INSERT AS
Type VARCHAR2_I_TABLE IS TABLE OF VARCHAR2(300)
I can not get the type name, the type name I got is the package's name
