Re: Fwd: Re: Variable not found

Gilles Darold <gilles.darold@xxxxxxxxxx> · Fri, 22 Jan 2016 09:35:48 +0100



    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