When i trying to execute shell script , it does out come out. keep on running
0
votes
0
answers
51
views
File name:
/u02/app/scmdw/scr/appcheck1.sql
Shell script: test.ksh
#!/bin/ksh
line=sqlplus $SCMDWSA @/u02/app/scmdw/scr/appcheck.sql
echo "== Result of SQL: line = $line"
When I try to execute the shell script test.ksh
, the following step:
sqlplus $SCMDWSA @/u02/app/scmdw/scr/appcheck.sql
The script keeps running and does not exit.
I want to check how it works if I change the filename from appcheck.sql
to appcheck1.sql
in the directory path.
I also want to capture the error if an invalid file is kept in the actual directory path.
Could you please help me understand how to capture the error and why is it running for such a long time?
Asked by Celestica - Prabhahar Palanive
(19 rep)
Oct 14, 2024, 05:53 AM
Last activity: Jun 24, 2025, 11:59 AM
Last activity: Jun 24, 2025, 11:59 AM