Re: Variable not found

On 01/20/2016 07:35 PM, Sachin Srivastava wrote:
> Dear Folks,
>
> I have a question about global variables in Oracle pl/sql package. Where
> are these variables when package is converted to schema from Oracle to
> Postgres through Ora2PG Tool?
>
>
> For example, package <SSJ4_COMPLIANCE_PKG has a global variable
> g_compliance_id. This package is converted to schema
> ssj4_compliance_pkg, but I cannot find where is the variable
> g_compliance_id. It must be somewhere because there is no error in
> functions which reference this variable. Please suggest where I will
> fount it, any idea?

Best guess it is stored in a table in the schema.

>
>
> Regards,
>
> SS
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com