Error in SQL*Plus when Using Shell Script
(Doc ID 1472150.1)
Last updated on JULY 27, 2018
Applies to:SQL*Plus - Version 10.1.0.2 to 126.96.36.199 [Release Oracle10g to 11.2]
When using bash profile to execute SQL commands, it errors out when it encounters some special characters.
For example, consider the following script:
The select count(*) from v_$session will work absolutely fine when issued directly using sqlplus, whereas when issued through shell script it errors out.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document