Re: orafce bug issue

Hi Tom,

Thanks for the update and please let me know how can we check the version
and incompatibility.

*orafce | 3.8 | public | Functions and operators
that emulate a subset of functions and packages from the Oracle RDBMS* for
another one server i created successfully this time only getting error for
other server.

regards, prakash.

On Thu, May 2, 2019 at 7:49 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Prakash Ramakrishnan <prakash(dot)ramakrishnan(dot)ap(at)nielsen(dot)com> writes:
> > while we are creating the orafce extension getting below error.
> > AIBE01PR=# create extension orafce;
> > ERROR: could not load library "/usr/pgsql-11/lib/orafce.so":
> > /usr/pgsql-11/lib/orafce.so: undefined symbol: DatumGetFloat4
>
> Perhaps that extension was compiled against some old version of
> Postgres (probably 9.6 or earlier)? Ideally you'd get a version
> incompatibility complaint first ... but unfortunately if the dynamic
> linker is unhappy, that's going to come out before we can find out
> what version the .so is for.
>
> regards, tom lane
>

--

Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call
: +91-8939599426