Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


ORA-22927: invalid LOB locator specified



ORA-22927: invalid LOB locator specified..

Answer / guest

Cause: There are several causes: (1) the LOB locator was
never initialized; (2) the locator is for a BFILE and the
routine expects a BLOB/CLOB/NCLOB locator; (3) the locator
is for a BLOB/CLOB/NCLOB and the routine expects a BFILE
locator; (4) trying to update the LOB in a trigger body --
LOBs in trigger bodies are read only.

Action: For (1), initialize the LOB locator by selecting
into the locator variable or by setting the LOB locator to
empty. For (2) and (3), pass the correct type of locator
into the routine. For (4), remove the trigger body code that
updates the LOB value.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

O2F-00304: Invalid filename for the INTYPE file

1 Answers  


PLS-01453: This procedure is not part of the ANSI standard

1 Answers  


EXP-00013: respond with either 'Y', 'N', RETURN or '.' to quit

1 Answers  


NPL-00415: received unsupported ASN.1 INDEFINITE-LENGTH encoding

1 Answers  


SQL*Loader-00810: error creating external table: string

1 Answers  


ORA-25406: could not generate a connect address

1 Answers  


DRG-12433: load of string JDBC driver class failed

1 Answers  


ORA-13613: The requested operation is not supported for this advisor object.

1 Answers  


ORA-32628: invalid nesting of MODEL cell reference

1 Answers  


LPX-00118: undefined entity "~S"

1 Answers  


ORA-02053: transaction string committed, some remote DBs may be in-doubt

1 Answers  


ORA-29512: incorrectly formed name resolver specification

1 Answers  


Categories