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?
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With