CODEWITHSUNDEEP
sqlplsql
FireVortex
FireVortex

Reputation: 343

How to access declared type in package, is it possible?

When I create varray in one package, for example type MyArray Is Varying Array(20) Of Varchar2(512);

is it possible to access from another package (or from anywhere) myPackage.MyArray...??? Or how to solve the problem, that I need MyArray everywhere (can't use global type...)

Thanks!

Upvotes: 0

Views: 69

Answers (1)

Ajith Sasidharan
Ajith Sasidharan

Reputation: 1155

yes u create this variable in your package specification and access it like mypackage.variable for your session. You can either use PRAGMA SERIALLY_REUSABLE;

Upvotes: 1

Related Questions