Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Dropping/Creating Stored Procedures

Re: Dropping/Creating Stored Procedures

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Wed, 02 Feb 2000 00:48:30 +0200
Message-ID: <389762BE.ECBF731@0800-einwahl.de>


Which error message do you get?

Martin

ejrchurch_at_my-deja.com wrote:
>
> I am unable to drop some stored procedures in my
> schema. Previously, I was able to drop and create
> stored procedures freely. My system privileges
> have not changed. For a stored procedure "proc",
> the statement "DROP PROCEDURE proc" fails to drop
> the procedure. The drop statement does not raise
> an exception, but nor does it complete; I am
> forced to cancel the transaction. These facts lead
> me to believe that Oracle perceives the procedure
> is still in execution, which it is not. I am using
> Oracle 7.3.4. Any ideas why this is occurring?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Feb 01 2000 - 16:48:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US