PL/SQL (MOSC)

MOSC Banner

ORA-04021: timeout occurred while waiting to lock object

edited Oct 29, 2015 7:55AM in PL/SQL (MOSC) 3 commentsAnswered

Fallowing piece of code get above error when running table with 65 million records.

any clue?

!!!Error occurred while executing Plsql Block at 15-OCT-15 19:22:22
DECLARE

   CURSOR get_con_removed_records IS
      SELECT rowid
      FROM project_snapshot_data_tab
      WHERE transaction_currency_code IS NULL
      AND connection_removed = 'TRUE';

   TYPE project_snapshot_data_ IS TABLE OF get_con_removed_records%ROWTYPE INDEX BY BINARY_INTEGER;
   project_snapshot_data_tab_ project_snapshot_data_;

   bulk_limit_ NUMBER := 100000;

BEGIN
   IF NOT Database_SYS.Is_Db_Patch_Registered('PROJBF', 118986) THEN
      OPEN get_con_removed_records;
      LOOP
         FETCH get_con_removed_records BULK COLLECT INTO project_snapshot_data_tab_ LIMIT bulk_limit_;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center