ORA-22926: specified trim length is greater than current LOB
value's length



ORA-22926: specified trim length is greater than current LOB value's length..

Answer / guest

Cause: The input length for which to trim the LOB value to
is greater than the current length of the LOB value.

Action: May not need to trim the LOB value because it's
already smaller than the trim length specified. Or, if
trimming the LOB value really is required, use a smaller
trim length.

Please add more information about this Error

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00169: modifier 'string' conflicts with prior 'string' specification

1 Answers  


ORA-36178: (XSAGGR01) To be used with AGGREGATE, AGGMAP workspace object must be declared with the AGGMAP command.

1 Answers  


ORA-22276: invalid locator for LOB buffering

1 Answers  


ORA-31216: DBMS_LDAP: PL/SQL - Invalid LDAP rdn.

1 Answers  


ORA-01070: Using an old version of Oracle for the server

1 Answers  






ORA-28510: heterogeneous database link initialization failed

1 Answers  


DRG-13007: cannot define an alternate value for the DEFAULT sub lexer

1 Answers  


ORA-32100: operation invalid on transient object

1 Answers  


ORA-36708: (XSMXALLOC00) Variable workspace object must be dimensioned to be used by the ALLOCATE command.

1 Answers  


PLS-00640: a pipelined function cannot be called from PL/SQL context

1 Answers  


TNS-00087: * version - ask the process name to display its version number

1 Answers  


ORA-29373: resource manager is not on

1 Answers  


Categories