How to create a global type of Oracle and use it in PL / SQL?

Question

Oracle RECORD TYPE declared in a procedure or function is local, so it can only be used locally. How to declare a RECORD TYPE that is global and can be used in all procedures and functions globally in the database?

Answer 1

Record types cannot be created as a separate object of the circuit, therefore for public access of the Record type the type is usually declared in the package specification or the body of the package is available only in the volume of this package,

Answer 2

A basic example of using an object type in your package.

 CREATE OR REPLACE TYPE test_rec IS OBJECT ( ID VARCHAR2(30) ,TYPE VARCHAR2(30) ); / CREATE OR REPLACE TYPE test_NT AS TABLE OF test_rec; / declare v_test_NT test_NT; begin select test_rec (id ,type ) BULK COLLECT INTO v_test_NT FROM test ; --use it as you want end;