Run attached file in sql plus to create a type with a type body.
After this generate ddl from the type with preferences “Include drop” and “Body and Spec for Packages/Objects” set.
You get a similar file than the attached.
If you run the file inside navigator then you get an compile error (see type.jgp), as the last end statement is not included in the type body creation (see type2.jpg).
to_test.sql (433 Bytes)