Cancel executing query programmatically

Dear All.

I want to stop queries that executes for a long time.

I know that there is "Ctrl+C" or "Cancel Button" in sqlplus.

But How can I do it progmmatically, for example: in Delphi. I don't want you to give me example for Delphi, I mean which steps I have to do in order to do it?

Thanks in advance!!!

If your using scripts then u can kill the script

kill -9 scriptname

Or kill the session

alter system kill session 'sid,serial#';

regards
anandkl

Or even.. Kill the tread/process at OS level

a more elegant approach would be to create a resource plan and consumer groups so that users in X group can be limited to things like how much max execution time, undo quota , cpu usage etc