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

ORA-24758: not attached to the requested transaction

1 Answers  


PCB-00901: Pro*COBOL internal error condition detected (Code = number)

1 Answers  


TNS-00014: INTCTL: error while opening terminal input channel

1 Answers  


ORA-13362: disjoint sub-element in a compound polygon

1 Answers  


ORA-02206: duplicate INITRANS option specification

1 Answers  


ORA-09873: TASDEF_OPEN: open error when opening tasdef@.dbf file.

1 Answers  


ORA-01687: specified logging attribute for tablespace 'string' is same as the existing

1 Answers  


PCC-02040: CMD-LINE: Option selected, but no value provided

1 Answers  


PCB-00104: Unable to open input file "string"

1 Answers  


ORA-15063: diskgroup "string" lacks quorum of string PST disks; string found

1 Answers  


ORA-36690: (NTEXTCNV01) Error during conversion from NTEXT to TEXT.

1 Answers  


ORA-23358: invalid remote user

1 Answers  


Categories