Re: Variable not found - Mailing list pgsql-general

From Sachin Srivastava
Subject Re: Variable not found
Date
Msg-id CAFzqEhKa-qoQ8QraowD5LynVpTw3ky5o=C-y3du1U9cr6K5N5Q@mail.gmail.com
Whole thread Raw
In response to Re: Variable not found  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Variable not found
List pgsql-general
Dear Adrian,

So, how the effective way to search this because I have around 1300 tables.

Regards,
SS

On Thu, Jan 21, 2016 at 8:48 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
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

pgsql-general by date:

Previous
From: David E. Wheeler
Date:
Subject: Let's Do the CoC Right
Next
From: Rajeev Bhatta
Date:
Subject: Re: Let's Do the CoC Right