Re: Remove DBMS_LOCK Locks

On Wed, 20 Jun 2007 15:01:23 -0400, "klabu" <klabu_at_mailinator.com> wrote:

>10gR2
>
>there're many many records in "dbms_lock_allocated" from my previous
>testing, and I recognize the names
>I know they're useless now
>
>If they can/should be removed, how to do it ?
>
>DBMS_LOCK.RELEASE(<lockid>) ;
>returns " Parameter error"
>
>
>SQL> desc sys.dbms_lock_allocated
>Name Type Nullable Default Comments
>---------- ------------- -------- ------- --------
>NAME VARCHAR2(128)
>LOCKID INTEGER Y
>EXPIRATION DATE Y
>
>
>thanks
>

From your post it is unclear how you are calling dbms_lock.release. You didn't type *litterally*
exec dbms_lock.release(<lockid>);
did you?

-- 
Sybrand Bakker
Senior Oracle DBA