ERROR: invalid macro name in dynamic library path: $lib/orafce

[M Vadiraj]

Hi all

I am trying to install "bugfix of precompiled dll of Orafce 3.6.2" from
http://okbob.blogspot.com/2017/12/bugfix-of-precompiled-dll-of-orafce-362.html
on Windows 10 and I am getting the below error when I execute "create extension orafce; in PostgreSQL 10".

ERROR:  invalid macro name in dynamic library path: $lib/orafce
SQL state: 42602

Server: PostgreSQL 10

The orafce.control file is as follows::

C:\Program Files\PostgreSQL\10\share\extension\orafce.control

# intarray extension
comment = 'Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS'
default_version = '3.6'
module_pathname = '$lib/orafce'
relocatable = false

I have copied all the *.sql files to..
C:\Program Files\PostgreSQL\10\share\extension

and all the dlls to
C:\Program Files\PostgreSQL\10\lib

Any help is greatly appreciated.

Thanks in advance.

Regards
Vadi
Bengaluru
India

[M Vadiraj]

[Ramkumar Chandrasekaran]

module_pathname = '$lib/orafce'

Or 

module_pathname = '$libdir/orafce'

https://github.com/orafce/orafce/blob/master/orafce.control

Sent from my iPhone

--
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.

[M Vadiraj]

Hi Mr Ramkumar

Thanks for the reply.

As I have said in my post...

I have used module_pathname = '$lib/orafce'

since module_pathname = '$libdir/orafce' did not work.

Thanks again.

Regards

Vadi

[Ramkumar Chandrasekaran]

Can you share the error message that you get when using module_pathname = '$libdir/orafce'

[M Vadiraj]

Hi Mr Ramkumar

Thanks for your reply.

I am still not able to create the orafce extension.

I am getting the below error:

ERROR: could not access file "$libdir/orafce": No such file or directory SQL state: 58P01

My "orafce.control" file is as follows:

# intarray extension
comment = 'Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS'
default_version = '3.6'

module_pathname = '$libdir/orafce'
relocatable = false

Thanks again.

Regards

Vadi

[Pavel Stehule]

st 20. 2. 2019 v 4:40 odesílatel M Vadiraj <mvad...@gmail.com> napsal:

Hi Mr Ramkumar

Thanks for your reply.

I am still not able to create the orafce extension.

I am getting the below error:

ERROR: could not access file "$libdir/orafce": No such file or directory SQL state: 58P01

looks like wrong path or wrong access settings. Can you check, so these files are readable for system user used for execution postmaster.

[Ramkumar Chandrasekaran]

Hi Vadiraj, 

There needs to be only one orafce.dll in C:\Program Files\PostgreSQL\10\lib

rename orafce-10-x64.dll as orafce.dll and remove other dlls. 

On Tuesday, February 12, 2019 at 3:22:45 AM UTC-8, M Vadiraj wrote:

[M Vadiraj]

Hi Mr Ramkumar

It worked :-)

Thanks a lot for your help.

I have given some screenshots below, just for your information.

Hopefully this will also help other people.

Thanks again. Your help is much appreciated.

Regards

Vadi

Bengaluru

India