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

ORA-00487: CTWR process terminated with error

1 Answers  


ORA-19024: Cursor expression must be named

1 Answers  


ORA-36312: (PHYS00) workspace object must be a dimension or dimensioned variable.

1 Answers  


ORA-32108: max column or parameter size not specified

1 Answers  


ORA-32771: cannot add file to bigfile tablespace

2 Answers  


ORA-26680: object type not supported

1 Answers  


ORA-26018: Column string in table string does not exist

1 Answers  


ORA-27030: skgfwrt: sbtwrite2 returned error

1 Answers  


ORA-15050: disk "string" contains string error(s)

1 Answers  


TNS-04207: Trace Assistant Internal ERROR: Packet Length

1 Answers  


EXP-00098: Data in table has not been upgraded, table will not be exported

1 Answers  


DRG-12802: invalid type column: string

1 Answers  


Categories