Code problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Code problem

  1. #1
    Join Date
    Jul 2001
    Posts
    181

    Smile

    This loop is at the end of a procedure I have, it should truncate the aforementioned table.

    However I get the error:

    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    204/5 PLS-00103: Encountered the symbol "PROCESSENTITYDELETIONS" when
    expecting one of the following:
    loop

    BEGIN
    --LOOP Delete_Entity_Loop
    LOOP
    --
    -- Now to truncate the tibex_deleteAction
    --
    log_message(' Truncating the tibex_deleteAction table.');
    execute immediate 'truncate table tibex_deleteAction';

    log_message(' Completed processEntityDeletions: ' || v_processed
    || ' entries processed');
    END LOOP;
    END;
    END processEntityDeletions;


    please advise!!!



  2. #2
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    I would change

    END processEntityDeletions;

    in

    END ; -- processEntityDeletions



  3. #3
    Join Date
    Mar 2002
    Posts
    2
    There's and extra 'END' in the code. The last matches to the 'BEGIN' and the second to last matches to 'LOOP', leaving the 'END LOOP' hanging out there.

Posting Permissions

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



Click Here to Expand Forum to Full Width