Description:
arrow is built with static library support enabled. The generated static library is not packaged as there is a matching shared library. This breaks cmake support.
This is distinct from  FS#74566  as I do not need the static library only working cmake support so I suggest building with static library support disabled.
This involves some changes to apache-orc so it provides a shared library otherwise the build fails due to unresolved symbols from the shared zstd in the static liborc.
Additionally fix apache-orc upstream variable reversal that prevents use of shared zlib.

Additional info:
* arrow 7.0.0-4
* config and/or log files etc.
* link to upstream bug report, if any

Steps to reproduce:
Build the attached ceph-17.2.0-1.src.tar.gz which fails with
CMake Error at /usr/lib64/cmake/arrow/ArrowTargets.cmake:96 (message):
The imported target "arrow_static" references the file

"/usr/lib/libarrow.a"

but this file does not exist. Possible reasons include:

* The file was deleted, renamed, or moved to another location.

* An install or uninstall procedure did not complete successfully.

* The installation package was faulty and contained

"/usr/lib64/cmake/arrow/ArrowTargets.cmake"

but not all the files it references.

Call Stack (most recent call first):
/usr/lib64/cmake/arrow/ArrowConfig.cmake:83 (include)
cmake/modules/FindArrow.cmake:226 (find_package)
cmake/modules/FindArrow.cmake:347 (arrow_find_package_cmake_package_configuration)
cmake/modules/FindArrow.cmake:392 (arrow_find_package)
src/CMakeLists.txt:857 (find_package)


-- Configuring incomplete, errors occurred!