users
[Top] [All Lists]

Returning 4K+ from a Java Stored Procedure

To: users@xxxxxxxxxx
Subject: Returning 4K+ from a Java Stored Procedure
From: Creighton Kirkendall <ckirkendall@xxxxxxxxxxxxxx>
Date: Fri, 23 Sep 2005 09:45:56 -0400
Delivered-to: mailing list users@cinjug.org
Mailing-list: contact users-help@cinjug.org; run by ezmlm
I am trying to return an xml document from a java stored procedure. 
This document is over the 4K limit for VARCHAR2 (my original return
type) so I am trying to figure out how to return this object.  Right now
it seems not matter what data type I choose I get the following error.

ORA-24345: A Truncation or null fetch error occurred

Does anyone out there have experience with returning more than 4K from a
java stored procedure.


Creighton




<Prev in Thread] Current Thread [Next in Thread>