build Orafce 3.3 for MS Windows platform

[Pavel Stehule]

Hi,

here is compiled dll for MS Win PostgreSQL 9.2, 9.3, 9.4 and 9.5.

Install steps:

1. unzip to some directory

2. choose right dll file, rename to orafce dll and copy to PostgreSQL lib directory

3. copy orafce.control and *.sql files to PostgreSQL share/extension directory

as user postgres run "create extension orafce" in choosed database.

Regards

Pavel

[PAscal L]

Great, I will test it next week !
Thank you

Regards
PAscal

[Nguyen Van Hoang]

Useful, thank Pavel. This zip save more time for me.

Dne pondělí 11. dubna 2016 19:17:49 UTC+7 Pavel Stehule napsal(a):

[Jab Jolt]

Thanks a lot, Pavel! It works fine!

Tested on Windows Server 2008 x64, with running Postgre 9.5 (x64) on it.

Can you tell some way to circumvent the "oracle." prefix in using oracle functions? May be there is a way to extend or add namespace in Postgre?

Thanks in advance!

[Pavel Stehule]

you can set search_path

http://www.postgresql.org/docs/9.1/static/runtime-config-client.html

ALTER DATABASE xxx SET search_path = oracle,public;

Pavel

Thanks in advance!

--
You received this message because you are subscribed to the Google Groups "Better Oracle functions support" group.
To post to this group, send email to orafce-...@googlegroups.com.
Visit this group at https://groups.google.com/group/orafce-general.

[Sreenivasa Atchi]

Hi Pavel,

   I am new to Postgres world. I tried to create orafce in my Postgres 11 on windows 7 but got below error.

   ERROR: could not load library "C:/Program Files/PostgreSQL/11/lib/orafce.dll": The specified procedure could not be found.

I copied all files from orafce-3.3.zip.

Please help me in this.

Thanks,

Srini

[Pavel Stehule]

Hi,

Orafce 3.3 is probably too old, where PostgreSQL 11 was not supported.

Postgres extensions have to be compiled against choosed Postgres release. You cannot to use Orafce for Postgres 10 with Postgres 11.

Please try to use last Orafce http://okbob.blogspot.com/2019/10/precompiled-libraries-for-orafce-38-for.html

Install steps:

1. unzip to some directory

2. choose right dll file, rename to orafce dll and copy to PostgreSQL lib directory

3. copy orafce.control and *.sql files to PostgreSQL share/extension directory

as user postgres run "create extension orafce" in choosed database.

Regards

Pavel

so 8. 2. 2020 v 6:56 odesílatel Sreenivasa Atchi <srat...@gmail.com> napsal:

--
You received this message because you are subscribed to the Google Groups "Better Oracle functions support" group.

To unsubscribe from this group and stop receiving emails from it, send an email to orafce-genera...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/6ecc5e57-4c75-4a47-8230-67ae50fcafa8%40googlegroups.com.

[Sreenivasa Atchi]

It worked.

Thank you very much

To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/CAFj8pRAuSq%2BBNM3WFuMbBesR7-i1wPwUkYc3%2BnwjpGFCvVGURQ%40mail.gmail.com.

[Pavel Stehule]

:)

Pavel

so 8. 2. 2020 v 15:01 odesílatel Sreenivasa Atchi <srat...@gmail.com> napsal:

To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/CAJsc7Cs-iuFxYKieomXS%2B8n5_Q%2BnpC-%2BxU725TMZ3DeSqjoBJw%40mail.gmail.com.

[Su Vay Tranh]

Hi @Pavel Stehule, 

Currently, I have been doing as your instructions, however, I got the following error

Could you please give me some instructions to fix this problem? I am installing orafce on Windows 10 environment and PostgreSQL 13. 

I am looking forward your response. Thanks