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

IMG-00824: fail queue pop failed

1 Answers  


ORA-24906: invalid recepient attribute passed into OCI call

1 Answers  


ORA-22979: cannot INSERT object view REF or user-defined REF

1 Answers  


TNS-12679: Native services disabled by other process but required

1 Answers  


ORA-14409: inserted partition key is outside specified subpartition

1 Answers  


ORA-24903: invalid namespace attribute passed into OCI call

1 Answers  


ORA-24055: cannot delete propagation status rows that are in prepared state

1 Answers  


ORA-19690: backup piece release string incompatible with Oracle release string

1 Answers  


ORA-15032: not all alterations performed

1 Answers  


LSX-00114: facet "~S" not in schema schema

1 Answers  


ORA-38715: Invalid log number specified in the DUMP FLASHBACK command.

1 Answers  


ORA-31438: duplicate change table string

1 Answers  


Categories