Re: Stop a PL/SQL stored procedure

From: DA Morgan <>
Date: Thu, 06 Sep 2007 06:41:01 -0700
Message-ID: <> wrote:
> In Oracle Sql Developer how can I stop a PL/SQL stored procedure that
> take long time to finish?
> Can I execute a sql command to stop that? What's the command?
> Thank you in advance,
> Pino
> (The oracle newbie)

Assuming client-server in a normal development environment the only thing you can do is ask the DBA to kill it. If you have privileges to kill it yourself any of these methods will work:

Daniel A. Morgan
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Thu Sep 06 2007 - 15:41:01 CEST

Original text of this message