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-22275: invalid LOB locator specified



ORA-22275: 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; (5) the locator is for
a BFILE/BLOB and the routine expects a CLOB/NCLOB locator;
(6) the locator is for a CLOB/NCLOB and the routine expects
a BFILE/BLOB locator;

Action: For (1), initialize the LOB locator by selecting
into the locator variable or by setting the LOB locator to
empty. For (2),(3), (5) and (6)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

KUP-04062: no data source specified

1 Answers  


ORA-30351: query rewrite does not currently support this expression

1 Answers  


TNS-00528: Protocol Adapter not loaded

1 Answers  


RMAN-06580: the string option cannot be used with AS COPY

1 Answers  


QSM-01104: query is using flashback

1 Answers  


ORA-24072: cannot execute MIGRATE_QUEUE_TABLE procedure; must own queue table

1 Answers  


ORA-25464: ROWID not specified for table alias: string

1 Answers  


ORA-07579: spini: $DCLEXH failure

1 Answers  


DRG-10205: server deregister failed

1 Answers  


IMP-00034: Warning: FromUser "string" not found in export file

1 Answers  


ORA-12671: Shared server: adapter failed to save context

1 Answers  


ORA-29885: domain index is defined on the column to be modified

1 Answers  


Categories