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 29, 2023

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.

Goal

On a 10.1.0.4 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).

Solution

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
Goal
Solution

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