Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2008

    Unanswered: ORA-00069 cannot acquire loc

    Hi, I am getting the Oracle Database error "ORA-00069 cannot acquire lock -- table locks disabled for string" in a stored proc. According to some sites I looked at, it says the Cause is "A command was issued that tried to lock the table indicated in the message. Examples of commands that can lock tables are: LOCK TABLE, ALTER TABLE ... ADD (...), and so on.". And the Action they suggest is "Use the ALTER TABLE ... ENABLE TABLE LOCK command, and retry the command".

    I am not doing either a lock table or alter table command in my procedure, so what else could be causing this?

    Thank you for any help. Sorry if this is an easy one, but I am new to Oracle.

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    My ability to debug unseen code is lacking.
    You should hope others are better at it than I am.

    My car won't go.
    Please tell me how to make my car go.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2010
    Hedgesville, WV
    I'll help you if you post the procedure's code. I might be able to find the error for you.

Posting Permissions

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