My Oracle Support Banner

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.

Symptoms

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:

...

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.