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-28533: Heterogeneous Services coercion handling error

1 Answers  


ORA-15170: cannot add entry 'string' in directory 'string'

1 Answers  


QSM-01075: materialized view, string, does not support aggregate function, string

1 Answers  


DRG-51024: out of memory in stemmer

1 Answers  


TNS-00044: INTCTL: You must have an INTCHG.ORA file to contact the Connection Manager

1 Answers  


ORA-02834: Server unable to open file

1 Answers  


ORA-30391: the specified rewrite equivalence does not exist

1 Answers  


RMAN-08591: WARNING: invalid archivelog deletion policy

1 Answers  


ORA-02279: duplicate or conflicting MINVALUE/NOMINVALUE specifications

1 Answers  


ORA-01528: EOF while processing SQL statement

1 Answers  


RMAN-06500: skipping backupset key string; already backed up string time(s)

1 Answers  


RMAN-08004: full resync complete

1 Answers  


Categories