ORA-24281: invalid access past the maximum size of LOB
parameter string



ORA-24281: invalid access past the maximum size of LOB parameter string..

Answer / guest

Cause: The value of positional or size parameters exceeds
the maximum allowed LOB size of 4 Gigabytes.

Action: Correct the input values for amount and offset such
that their sum is less than or equal to 4 Gigabytes. If
error occurs in a read or write loop, check the looping
conditions and/or offset increments.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-39070: Unable to open the log file.

1 Answers   IBM,


ORA-00601: cleanup lock conflict

1 Answers  


IMP-00015: following statement failed because the object already exists:

1 Answers  


RMAN-08111: some blocks not recovered: See trace file for details

1 Answers  


NCR-00003: NCR: Initialization failure

1 Answers  






RMAN-02006: script line too long

1 Answers  


ORA-15010: name is already used by an existing ASM disk

1 Answers  


ORA-02843: Invalid value for kernel flag

1 Answers  


TNS-00145: PUMPS value in INTCHG.ORA is too large.

1 Answers  


ORA-27507: IPC error disconnecting from a port

1 Answers  


ORA-12150: TNS:unable to send data

1 Answers  


ORA-39708: component 'string' not a string component

1 Answers  


Categories