Hi
I have a stored procedure which should be called from KSH.
Could ayone please help me with this.
Thanks
Hi
I have a stored procedure which should be called from KSH.
Could ayone please help me with this.
Thanks
One of the approch is like below
SQL_FILE=/tmp/test.sql
chmod 755 $SQL_FILE
sqlplus -s connection_string <<!EOF
@${SQL_FILE}
!EOF