Hi, > > 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? >
Ora2Pg doesn't export global variable and any other element declared outside a package body. If you want to know how thoses variables was created under Oracle you can simply ask to Ora2Pg to export the source code of the packages. You will get the entire package declaration. To proceed set the PLSQL_PGSQL configuration directive to 0 and perform a PACKAGE export into a different directory: ora2pg -c config/ora2pg.conf -t PACKAGE -b path/to/sources/ -o pkgsrc.sql or if the directive is already disabled remove do not use the -p option. > > 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. As Adrian says, there's no equivalent with PostgreSQL. You will need to use custom variable in postgresql.conf or a table to store your global information. Best regards, -- Gilles Darold Consultant PostgreSQL http://dalibo.com - http://dalibo.org