Friday, December 2, 2022

prepared dll of orafce 4.0.1 and plpgsql_check 2.2.5 for PostgreSQL 14 and PostgreSQL 15

I compiled and uploaded zip files with latest orafce and plpgsql_check for PostgreSQL 14 and PostgreSQL 15.


  1. download or and extract files
  2. copy related dll file to PostgreSQL lib directory (NN is number of pg release)
    orafce-NN.dll -> "c:\Program Files\PostgreSQL\NN\lib"
  3. remove suffix "-14" or "-15" from dll file
    orafce-NN.dll -> orafce.dll
  4. copy *.sql and *.control files to extension directory
    *.sql, *.control -> "c:\Program Files\PostgreSQL\NN\share\extension"
  5. execute with super user rights SQL command CREATE EXTENSION


At January 11, 2023 at 12:50 AM , Anonymous 50festplatten said...

Informative and educative;)

At March 22, 2023 at 4:29 PM , Blogger Unknown said...

Hi Pavel. Where is the latest dll for PostgreSQL 13? Thank you.

At March 22, 2023 at 6:41 PM , Blogger Unknown said...

Hi Pavel. Will this work for PostgreSQL 13? I badly need the latest one for that version which includes the oracle.decode function. Thank you.

At March 24, 2023 at 12:19 PM , Blogger Pavel Stěhule said...

I usually do build of orafce just for latest PostgreSQL releases. There can be an exception, when I have some paying customers.

At June 26, 2023 at 1:09 AM , Blogger Mart said...

Hi Pavel,

Do you have compiled version of instead of Windwos .dll file) for Postgresql 15?

At September 28, 2023 at 8:50 AM , Anonymous Aleksander said...

Helo Pavel,
Are you going to prepare dll for PostgreSQL 16?

At October 8, 2023 at 11:26 PM , Blogger Pavel Stěhule said...

@Mart - yes, I'll build these dll probably next month


Post a Comment

Subscribe to Post Comments [Atom]

<< Home