Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 Oracle Database Error: ORA-22835      [Return To Oracle Error Index] Jump to:  
Oracle Error: ORA-22835

Error Description:
Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: string, maximum: string)

Error Cause:
An attempt was made to convert CLOB to CHAR or BLOB to RAW, where the LOB size was bigger than the buffer limit for CHAR and RAW types. Note that widths are reported in characters if character length semantics are in effect for the column, otherwise widths are reported in bytes.

Action:
Do one of the following:

1. Make the LOB smaller before performing the conversion, for example, by using SUBSTR on CLOB

2. Use DBMS_LOB.SUBSTR to convert CLOB to CHAR or BLOB to RAW.

.


There haven't been any comments added for this error yet. You may add one if you like.  Add a comment 
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 45 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?