Thread: orafce

 Hi Paolo,

   we have recently migrated orafce to github
 (https://github.com/orafce/orafce) and are in the middle of the process
 for migrating the mailing list to Google Groups.

   You are better off asking here:
 https://groups.google.com/forum/?fromgroups#!forum/orafce-general

 Thanks,
 Gabriele

 On Wed, 13 Mar 2013 09:48:19 +0100, Paolo Grifa <paolo.grifa@gmail.com>
 wrote:
> Hi all,
> I am quite new in postgres, having experience with Oracle.
> I was trying to migrate some very simple applications from Oracle and
> found out that some functions like TRUNC() are only available via an
> addon called "orafce". The problem is that it seems only available
> for
> Postgres 9.1, while we have obviously started with the latest
> release.
>
> Does anybody know how to compile orafce for 9.2 or if there is any
> other solution to add some basic oracle functions (dual table, TRUNC,
> ecc...)??
>
> Thanks a lot,
> Paolo

--
  Gabriele Bartolini - 2ndQuadrant Italia
  PostgreSQL Training, Services and Support
  Gabriele.Bartolini@2ndQuadrant.it - www.2ndQuadrant.it

Hello

2013/3/13 Paolo Grifa <paolo.grifa@gmail.com>:
> Hi all,
> I am quite new in postgres, having experience with Oracle.
> I was trying to migrate some very simple applications from Oracle and found
> out that some functions like TRUNC() are only available via an addon called
> "orafce". The problem is that it seems only available for Postgres 9.1,
> while we have obviously started with the latest release.

There are orafce for PostgreSQL 9.2.

download it from github

https://github.com/orafce/orafce

You can compile orafce via PGXS setup
http://www.postgresql.org/docs/9.1/static/extend-pgxs.html

or with postgresql source tarball
http://postgres.cz/wiki/Oracle_functionality_%28en%29#Instalation

>
> Does anybody know how to compile orafce for 9.2 or if there is any other
> solution to add some basic oracle functions (dual table, TRUNC, ecc...)??

some basic oracle function can be implemented with simple sql
functions as wrappers PostgreSQL functions

CREATE VIEW public.dual AS SELECT 'X'::varchar AS dummy;
REVOKE ALL ON public.dual FROM PUBLIC;
GRANT SELECT, REFERENCES ON public.dual TO PUBLIC;

Regards

Pavel


>
> Thanks a lot,
> Paolo