batch scriptin

[hrishy]

Hi All

I want to execute a procedure from windows Nt dos prompt..the procedure is there in the database..the code goes somethin like this

sqlplus -s system/manager
set serveroutput on
spool kill_session.log
exec kill_session;
spool off

exit

when i put that in a bat file and run it the dos window simply hangs it appaeras to do nuthin..i want to execute this procedure every half an hour..

regards
Hrishy

[adewri]

Hi

try running with -s option removed, that will show you the error if any.

Cheers!

[DaPi]

Put the SQL commands in a file and "sqlplus -s system/manager @filename"

(I have had probs with this when the file to execute was in the current directory - waits for a return - let you know if I find out what is going on).

[hrishy]

Hi Dapi ,Amar

thanks for those lightining fast responses..i have tried both without any result..

regards
Hrishy

[DaPi]

Is it waiting on keyboard input? What happens if you hit return?

[hrishy]

Hi Dapi

Its still balnk..nuthin happens when i hit the eneter key

regards
Hrishy

[DaPi]

I've been doing (e.g.) "sqlplus -S /nolog @D:\Utils\Stats\ContactStats" for years - (has a connect statement in the sql)

[hrishy]

Hi

Thanks guys its workin..now..:-)

regards
Hrishy

[marist89]

Use perl

[DaPi]

Come on, be brave , tell us why it wasn't working (perhaps save me a headache one day!)