CREATE OR REPLACE FUNCTION find_locked_rows (v_rowid ROWID, table_name VARCHAR2)
RETURN ROWID IS
x NUMBER;
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
EXECUTE IMMEDIATE 'Begin Select 1 into :x from '
|| table_name
|| '
where rowid =:v_rowid for update nowait; Exception
When Others Then :x:=null; End;'
USING OUT x, v_rowid;
ROLLBACK;
IF x = 1 THEN
RETURN v_rowid;
ELSIF x IS NULL THEN
RETURN NULL;
END IF;
END;
Halim, a Georgia Tech graduate Senior Database Engineer/Data Architect based in Atlanta, USA, is an Oracle OCP DBA and Developer, Certified Cloud Architect Professional, and OCI Autonomous Database Specialist. With extensive expertise in database design, configuration, tuning, capacity planning, RAC, DG, scripting, Python, APEX, and PL/SQL, he combines technical mastery with a passion for innovation. Notably, Halim secured 16th place worldwide in PL/SQL Challenge Cup Playoff on the year 2010.
Saturday, September 12, 2009
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
-
ASSM states3 weeks ago
-
UKOUG Discover 20241 month ago
-
-
-
-
-
-
-
-
Moving Sideways8 years ago
-
-
Upcoming Events...11 years ago
-
No comments:
Post a Comment