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

QSM-01012: SAMPLE clause present in FROM

1 Answers  


ORA-13142: invalid PROXIMITY window definition

1 Answers  


RMAN-05508: SET NEWNAME TO NEW not allowed (datafile string)

1 Answers  


ORA-13461: the interleaving type is not supported

1 Answers  


ORA-10661: Invalid option specified

1 Answers  


PCC-02433: Invalid host variable and attribute pairing

1 Answers  


PROC-00031: Storage device for the cluster registry is too small

1 Answers  


RMAN-06137: must have recovery catalog for REPORT SCHEMA AT TIME

1 Answers  


LPX-00408: right parenthesis missing in the XSL file

1 Answers  


IMG-00546: invalid page number specified

1 Answers  


ORA-02785: Invalid shared memory buffer size

1 Answers  


ORA-03208: partitioned type must be specified for a non-composite object

1 Answers  


Categories