On 01/21/2016 10:48 PM, Sachin Srivastava wrote:
Dear Adrian, So, how the effective way to search this because I have around 1300 tables.
See Gilles response. From that I gather global variables are not automatically transferred and it is up to you to decide where to put them. Per your original post saying there where no errors in the function, do you mean when the function was created or used?
Regards, SS On Thu, Jan 21, 2016 at 8:48 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> 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@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
