| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Sachin Srivastava <ssr(dot)teleatlas(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Variable not found |
| Date: | 2016-01-21 15:18:36 |
| Message-ID: | 56A0F6CC.1040700@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yury Zhuravlev | 2016-01-21 17:52:18 | Re: Building PostgreSQL 9.6devel sources with Microsoft Visual C++ 2015? |
| Previous Message | Adrian Klaver | 2016-01-21 15:11:41 | Re: Postgres and timezones |