ORDS 500 Internal Server Error Inserted Value Too Large For Column
(Doc ID 2874066.1)
Last updated on OCTOBER 12, 2022
Applies to:Oracle REST Data Services - Version 20.3 and later
Information in this document applies to any platform.
ORDS is limiting (when using OWA_TEXT.VC_ARR) the number of bytes being HTTP posted to endpoint. Results in "500 Internal Server Error".
A stored procedure defined to receive VARCHAR2 can receive up to 32767 characters without issues.
But if the stored procedure is defined to receive OWA_TEXT.VC_ARR or cg_arr (same as OWA_TEXT.VC_ARR TABLE OF varchar2(32767)), it can only receive up to 32000 instead of 32767.
Weblogic managed server log:
[ords1] [ERROR] [ACTIVE].ExecuteThread: '15' for
queue: 'weblogic.kernel.Default (self-tuning)'] ...
POST ... ...xxxxx.xxxxx 500 java.sql.SQLException:
Inserted value too large for column: "the 32001 characters posted"[[
InternalServerException [statusCode=500, logLevel=SEVERE, reasons=]
Caused by: java.sql.SQLException: Inserted value too large for column:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document