FindOracleInstantClient Transitive Dependency Missing

The provided /usr/share/cmake/Modules/FindOracleInstantClient.cmake doesn't include the libclntsh.so transitive dependency of libocci.so in the generated OracleInstantClient_LIBRARIES variable.

This means compiling works fine, but linking fails to find necessary files.

The workaround is to manually include the transitive dependency; cmake example:

target_link_libraries(${PROJECT_NAME} PUBLIC "${OracleInstantClient_LIBRARIES}")
target_link_libraries(${PROJECT_NAME} PUBLIC "/usr/lib/oracle/21/client64/lib/libclntsh.so")