Re: [GENERAL] Oracle database into PostgreSQL using Ora2PG tool. - Mailing list pgsql-general

From Neil Anderson
Subject Re: [GENERAL] Oracle database into PostgreSQL using Ora2PG tool.
Date
Msg-id CAEKCySsnnuvhKWg8Cu+s6a=n_T-TH4SkPXdFB-hq+DRH_9S0Fw@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Oracle database into PostgreSQL using Ora2PG tool.  (stevenchang1213 <stevenchang1213@gmail.com>)
Responses Re: [GENERAL] Oracle database into PostgreSQL using Ora2PG tool.
List pgsql-general
On 2 June 2017 at 11:57, stevenchang1213 <stevenchang1213@gmail.com> wrote:
>
>
> tell me where this function add_job_history() is?
> Actually, I don't think you can count on ora2pg to transform your pl/sql
> code to plpgsql or other (un)trusted procedural language code. It's not that
> simple!

I wonder, does plpgsql compilation check for existence of the
add_job_history function or is that a runtime check?

> you can type "\df  add_job_history"  in psql session to check it's existence
> if it belongs to public schema or access it using fully qualified name
> scheme.
>
>
> Steven
>

Attachment

pgsql-general by date:

Previous
From: Nicolas Paris
Date:
Subject: Re: [GENERAL] dump to pg
Next
From: Igor Neyman
Date:
Subject: Re: [GENERAL] Oracle database into PostgreSQL using Ora2PG tool.