compiling failed on Debian

[JPF76]

Hi, not sure if this the right place.
I tried to compile dbd::oracle on my Debian machine but failed.
in the cpanm log file this the first error:

Oracle.xs:330:82: warning: macro expands to multiple statements [-Wmultistatement-macros]

no google entry gave me clue how to solve it.

attached is the log file of the failed compile process, hope anybody can give me a pointer how to solve this.
build.log

[whindsx]

Oracle.xs:330:82: warning: macro expands to multiple statements [-Wmultistatement-macros]
is a warning that can probably be safely ignored.

Your actual error is:
/usr/bin/ld: cannot find -lclntshcore
collect2: error: ld returned 1 exit status

I'm not liking your LD_LIBRARY_PATH:
Your LD_LIBRARY_PATH env var is set to '/opt/instantclient_12_1/:/opt/instantclient_12_1'

It should be more like:
LD_LIBRARY_PATH=/opt/instantclient_12_1/lib

[JPF76]

after making sure libclntshcore was visible throughout the system it worked.
and once reinstalling with --force.

here are my last commands:

find / -name libclntshcore.*
525 ld -L/opt/instantclient_12_1/libclntshcore.so.12.1 -lclntshcore
526 ld -L/opt/instantclient_12_1 -lclntshcore
527 ln -s /opt/instantclient_12_1/libclntshcore.so.12.1 /opt/instantclient_12_1/libclntshcore.so
528 ld -L/opt/instantclient_12_1 -lclntshcore
529 export ORACLE_HOME=/opt/instantclient_12_1
530 export LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH
531 cpanm --verbose DBD::Oracle
532 cat /root/.cpanm/work/1694428630.346870/build.log
533 cat /root/.cpanm/work/1694428630.346870/build.log
534 cpanm --verbose DBD::Oracle --force