My Oracle Support Banner

ORA-24345 When Returning A Web Service Response From A Java Stored Procedure (Doc ID 400142.1)

Last updated on AUGUST 15, 2022

Applies to:

JDBC - Version 10.1.0 and later
Web Services - Version 10.1.0 and later
Information in this document applies to any platform.


On a database server, a web service is consumed by a java stored procedure.
This Java Stored Procedure returns a VARCHAR2 standing for a WebService response.

The question is to how to return from a Java Stored Procedure, a response whose size can be greater than 32767 (PLSQL limit for a VARCHAR2).


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

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