Re: DISCONNECT ALL FROM A COMMAND IN PROCEDURE !!!!!!!

You can't execute DDL across a link, only DML. Besides, the connection required to execute the kill commands would itself be killed by the process. You can kill processes at the operating system level and wait for SMON to clean them up, but that's less user-friendly than simply performing a scheduled shutdown.

hth.
Kevin.
http://www.kevinloney.com

naveen_arora_at_my-dejanews.com wrote in message <7299v3$83s$1_at_nnrp1.dejanews.com>...
>hi!,
>
>can any one tell me how to
>DISCONNECT all ORACLE CONNECTIONS on a db WITHOUT MAKING DB SHUT
>THROUGH A COMMAND LINE INTERFACE ON WINNT RUNNING ORACLE
>7.3.2 ?
>
>I have to do it in a APPLICATION from a PL/SQL STORED PROCEDURE..
>
>Can the command be given via a database link from remote end ?
>
>regards
>naveen
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Nov 10 1998 - 09:36:38 CST