Search Results

SQL> .sh script calling .sql file with out error.But am getting out as numbers 1 2 3 4 5 .... I am getting out like this. But the output is incorrect
@ test.sql $v_case_nbr

---------- Post...

Hi Rudic,

You mean to use .sh file like this.

#!/bin/sh
echo "please enter case:"
read v_case_nbr
echo "the case number entered is $v_case_nbr"
sqlplus wmtst/wmtst@wmtest <<EOF
@...

Hi All,
I am new to shell script. I am trying to pass value from .sh file to .sql file .
But I am able to run the .sql file from .sh file with values in sql file.
But I am unable to pass the...