Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009
    Posts
    46

    Unanswered: Error while droping Stored Procedure

    Hi,

    I want to drop stored procedure from my database but when i am droping this SP from using drop command it is giving me error:


    Error: ora-04021 timeout occurred while waiting to lock object procedure


    Can you please suggest me why this error is comming and how to come out with this problem

    regards
    prasad

  2. #2
    Join Date
    Aug 2009
    Posts
    262
    #1 Someone else is probably executing the package/procedure
    while you are trying to delete it.


    #2 you can find out who it is
    by checking the view dba_lock_internal that can
    be built using the catblock.sql script from the
    $ORACLE_HOME/rdbms/admin directory - and
    terminate their session if you can.


    By
    Jonathan Lewis


    can u post the result of

    SELECT sid||','||serial# username,
    status,
    MODULE,
    osuser,
    client_info,
    TO_CHAR(logon_time,'DD-MON-YY HH:MI: SSSS') loged_on
    FROM v$session
    WHERE osuser = '<your operating system user>';
    Last edited by mishaalsy; 04-07-10 at 05:18.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •