$ export PATH=$PATH:/home/user/sqlcl/bin
...and to set it on login, add it to .bash_profile:
Thank you for the answer, but it didn't work.
In reality, I am trying to run a GitLab-Runner on docker and on .gitlab-ci.yml I call a shell script file and then I try to connect sqlcl.
I am getting this error when I push a file into repository.
build/export_apex.sh: line 4: sql: not found
ERROR: Job failed: exit code 127
Set your path in the shell script you are calling.
If it doesn't work then yes, you are doing something wrong...
If it is the same error where the executable "sql" cannot be found then you are not setting the PATH correctly.
Where is the sql executable exactly, i.e. the FULL path to the sql executable?
For example cd to the location sql executable is :
$ cd sqlcl-19.1.0.094.1619/sqlcl/bin
...and assign that FULLpath to $PATH.
Or where your picture shows "6. sql"... assign the full path in front of "sql" akin to:
6. /home/gaz/sqlcl-19.1.0.094.1619/sqlcl/bin/sql ...
Basically stop using relative paths, instead use full paths.