0
votes
1answer
36 views

KSH script missinterpreting alias stored in SQL oracle DB

I have stored the path of my file in a table with as an alias (as the complete path was too long for the table's field). However, in my KSH script, when I am doing : nomtmp=`sqlplus -S bla/bla ...
1
vote
1answer
479 views

Error out shell script if plsql program fails

In the shell script, I am calling a PLSQL stored procedure sqlplus -s <<EOF $v_fcp_login set head off feed off serverout on size 1000000 exec ...
3
votes
2answers
4k views

Replace all occurrences of a character in a variable using korn script

Part of the Korn script I am writing requires that I replace all occurrences of the ' character with two occurrences (''). I am trying to log some SQL that I am generating in this script to a column ...