Oracle – Possible to create Oracle Database object types inside of PL/SQL


Is it possible to create an object type inside of a package in Oracle Database 10g? Something like:

create or replace package my_package as 
    type my_type as object (
        id number(15) 


Error(3,9): PLS-00540: object not supported in this context.

What I'm ultimately looking to be able to do is use polymorphism but also allow the objects to access tables and use PL/SQL, which isn't allowed in types defined outside of packages.


Best Answer

From the Oracle 10g documentation:

Currently, you cannot define object types in a PL/SQL block, subprogram, or package.

So, unfortunately, no.