Re: Question on Rollback

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 12 Oct 1999 09:04:23 +0100
Message-ID: <939715558.13285.0.nnrp-12.9e984b29@news.demon.co.uk>

create or replace package pp as

    procedure p1;
    procedure p2;
end;
/

create or replace package body pp as

    procedure p1 is
    begin

        p2;
    end;

    procedure p2 is
    begin

        p1;
    end;

end;
/

Don't invoke either procedure as this stands, you may have to abort the database and
reboot the system (if you are on an NT box).

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

    Hakan Eren wrote in message <380245F6.53187D4F_at_iprimus.ca>...     Hi,
    Is it possible to create p1 without errors in Oracle8 (Without p2). = As far as I know You cannot do that

    in Oracle7. If it is possible I think that may cause some deadlock = problems, for example:

    SQLWKS> CREATE OR REPLACE PROCEDURE p1 
         2> IS 
         3> BEGIN 
         4>   p2; 
         5> END p1; 
         6> / 

    MGR-00072: Warning: PROCEDURE P1 created with compilation errors.

    SQLWKS> CREATE OR REPLACE PROCEDURE p2 
         2> IS 
         3> BEGIN 
         4>   p1; 
         5> END p2; 
         6> / 

    MGR-00072: Warning: PROCEDURE P2 created with compilation errors.     SQLWKS> ALTER PROCEDURE p1 COMPILE;     ALTER PROCEDURE p1 COMPILE
    *
    ORA-04045: errors during recompilation/revalidation of SCOTT.P2     ORA-04020: deadlock detected while trying to lock object SCOTT.P1     SQLWKS> ALTER PROCEDURE p2 COMPILE; Received on Tue Oct 12 1999 - 03:04:23 CDT