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-08103: object no longer exists

1 Answers  


ORA-25307: Enqueue rate too high. Enable flow control

3 Answers  


NZE-28770: Data source is already initialized.

1 Answers  


ORA-13521: Unregister operation on local Database id (string) not allowed

1 Answers  


ORA-02030: can only select from fixed tables/views

1 Answers  


KUP-04068: internal error fetching attribute string

1 Answers  


ORA-17613: Failed to initialize Oracle Disk Manager library: string

1 Answers  


ORA-14630: subpartition resides in offlined tablespace

1 Answers  


PCC-02205: Parser error at line number, column number, file string:

1 Answers  


ORA-01193: file string is not the same file seen at start of recovery

1 Answers  


ORA-13455: GeoRaster metadata TRS error

1 Answers  


NNO-00329: server will save the config file in number seconds

1 Answers  


Categories