Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

Tags:

oracle

plsql

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

like image 829
Centurion Avatar asked Feb 19 '23 22:02

Centurion


1 Answers

Record types cannot be created as a separate schema object, so to make a Record type publicly available the type is usually declared in a package specification, or a package body to be available only in the scope of that package.

like image 195
Nick Krasnov Avatar answered Feb 21 '23 18:02

Nick Krasnov