Hi, I have written a shell script in which I need to connect to sqlplus and execute some query there. In doing so on executing the shell script the query gets executed successfully but is not able to exit from sqlplus and as a result the shell script falls into a loop. Please suggest me the possible solution kalyan

Two suggestions: 1) You'll probably not get help without posting code examples stating exactly what the problem is. 2) Search this forum for 'sqlplus'. There are a number of examples which might help you.

The script is: #!/usr/bin/ksh path_1=/appworx/dir01/file1/script1 sqlplus -s loginid/password@AW01 @/appworx/dir01/file1/script1/Test.sql job1.1=$(grep "ABC" $path_1/test10.csv | awk '{print $2}') echo ABC,$job1.1 > $path_1/testoutput.csv AND THE QUERY IS in Test.sql: set serveroutput on size 50000 spool /appworx/dir01/file1/script1/test10.csv select so_module, to_char(SO_JOB_STARTED,'HH24:MI') SO_START_DATE from so_job_history where so_module in ( 'ABC', 'DEF' ) and so_job_finished between sysdate-1 and sysdate ; spool off The query is getting executed properly but after that its not coming out from sqlplus kalyan

I'm not an Oracle guy, but most of the guys I know use a Unix here document. Check these 2 links out: http://www.computing.net/answers/un... http://www.computing.net/answers/un...

I tried by adding: EXIT EOF at the end of Sql query but still its not working. Could anyone help me out regarding this. kalyan

You do not need the EOF since you are not using a here-document. But adding the EXIT to your sql script should have worked. The EOF on the following line would not hurt, as it would exit first. If this is still an issue, please post the latest version of your sql script.

try this for your file: / set serveroutput on size 50000 spool /appworx/dir01/file1/script1/test10.csv select so_module, to_char(SO_JOB_STARTED,'HH24:MI') SO_START_DATE from so_job_history where so_module in ( 'ABC', 'DEF' ) and so_job_finished between sysdate-1 and sysdate ; spool off EXIT / That's the way I have all of mine structured when I run queries within ksh scripts and it works fine.