-
batch scriptin
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
-
Hi
try running with -s option removed, that will show you the error if any.
Cheers!
Amar
"There is a difference between knowing the path and walking the path."
-
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).
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
Hi Dapi ,Amar
thanks for those lightining fast responses..i have tried both without any result..
regards
Hrishy
-
Is it waiting on keyboard input? What happens if you hit return?
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
Hi Dapi
Its still balnk..nuthin happens when i hit the eneter key
regards
Hrishy
-
I've been doing (e.g.) "sqlplus -S /nolog @D:\Utils\Stats\ContactStats" for years - (has a connect statement in the sql)
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
Hi
Thanks guys its workin..now..:-)
regards
Hrishy
-
Use perl
Jeff Hunter
-
Come on, be brave , tell us why it wasn't working (perhaps save me a headache one day!)
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|