ORA-22920
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-22920

  1. #1
    Join Date
    Apr 2001
    Posts
    46

    How do we rectify this error?
    please give the answer with some examples
    ORA-22920 row containing the LOB value is not locked
    Cause: The row containing the LOB value must be locked before updating the
    LOB value.
    Action: Lock the row containing the LOB value before updating the LOB value.

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hello

    In your dml you gotta use something like this

    select * ...........

    from ................

    for update;

    for update here will obtain a lock .this should solve your problem.for specific help on the query .post your query here.

    regards
    hrishy

  3. #3
    Join Date
    Apr 2001
    Posts
    46
    Originally posted by hrishy
    Hello

    In your dml you gotta use something like this

    select * ...........

    from ................

    for update;

    for update here will obtain a lock .this should solve your problem.for specific help on the query .post your query here.

    regards
    hrishy

    Thanx for giving the reply

    after putting the for updatae at the end of the select atatement then we are getting the following error

    ORA-01002 fetch out of sequence
    Cause: In a host language program, a FETCH call was issued out of sequence.
    A successful parse-and-execute call must be issued before a fetch. This can
    occur if an attempt was made to FETCH from an active set after all records have
    been fetched. This may be caused by fetching from a SELECT FOR UPDATE
    cursor after a commit. A PL/SQL cursor loop implicitly does fetches and may
    also cause this error.
    Action: Parse and execute a SQL statement before attempting to fetch the data.

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    hello

    I think your are using Dynamic sql if so plaese post your entire query here.one of us would give you a solution.

    regards
    Hrishy

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