Skip to Content
0
Former Member
Apr 15, 2008 at 07:39 AM

Explicit UNLOCK in procedure / trigger

113 Views

Hello,

how can I explicitly unlock my lock in stored procedure/trigger ?

When I try:

DROP DBPROC TEST_TMP
//
CREATE DBPROC TEST_TMP AS
BEGIN
  LOCK (WAIT) TABLE ADMIN.MOBILE
    IN EXCLUSIVE MODE;
  UNLOCK TABLE ADMIN.MOBILE
    IN EXCLUSIVE MODE;
END;
I obtain an error message:

Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed Syntax error or access violation;-5015 POS(87) Missing keyword:LOCK,WHILE,UPDATE,SELECT,INSERT,IF,EXECUTE,DELETE,CLO ...

What am I doing incorrect ?

What is the correct syntax ?

Thank you, Dusan