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

Last updated on AUGUST 03, 2016

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms