For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
How can we reference environment variables in sqlcl?
We have a bunch of sql scripts that call other sql scripts using a environment variables
eg (Windows OS).
@%sql_path%/dba.sql
Using sqlcl, this does not work.
Any idea?
John
"rdkafka.c", line 4837: undefined symbol: DT_REG "rdkafka.c", line 4837: improper member use: d_type "rdkafka.c", line 4837: undefined symbol: DT_LNK "rdkafka.c", line 4838: improper member use: d_type "rdkafka.c", line 4838: undefined symbol: DT_DIR
Those errors indicate this code is written to use Linux extensions to the POSIX API's which are not available on Solaris, specifically the d_type field in struct dirent. You'll have to adapt the code to make it build on Solaris - some examples from other open source projects: https://grok.cz.oracle.com/source/xref/userland-default/components/pcsc-lite/patches/02-configfile.c.patch https://www.virtualbox.org/svn/vbox/trunk/src/VBox/Runtime/r3/posix/dir-posix.cpp https://mail.python.org/pipermail/python-checkins/2015-March/134835.html https://git.gnome.org/browse/glib/commit?id=8863071b9d17fa37036549b8c6579736d259a9cd https://gitlab.freedesktop.org/mesa/mesa/commit/066850edadfe2aa0d339a0c6211ef0a61755a415