Re: [cinjug-users] Returning 4K+ from a Java Stored Procedure

users

Re: [cinjug-users] Returning 4K+ from a Java Stored Procedure

To:	Creighton Kirkendall <ckirkendall@xxxxxxxxxxxxxx>, users@xxxxxxxxxx
Subject:	Re: [cinjug-users] Returning 4K+ from a Java Stored Procedure
From:	Abdul Habra <ahabra@xxxxxxxxx>
Date:	Fri, 23 Sep 2005 09:13:04 -0700 (PDT)
Delivered-to:	mailing list users@cinjug.org
Domainkey-signature:	a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=qCFKrJBOAbEeEwc9jl+ehKnbWNYZOL3xxKmfnj0cRHynsM4Nq+aiERVZddpl9/ehadWlKzyQdw+Fvhmw/AWfPw3usMuHjHAZVGwjlZgd0SErGWoi9qdpdn0ghUH0O+MlcGbGwesxIluMUyFCzShdz5WXVKPqDrEllTNPPcz1+CQ= ;
In-reply-to:	<1127483156.2681.121.camel@localhost.localdomain>
Mailing-list:	contact users-help@cinjug.org; run by ezmlm

Did you consider using a CLOB type?

Creighton Kirkendall <ckirkendall@xxxxxxxxxxxxxx> wrote:

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

---------
You may unsubscribe from this mailing list
by sending a blank email addressed to:
users-unsubscribe@xxxxxxxxxx

--
Find additional help by sending a blank email
addressed to:
users-help@xxxxxxxxxx

Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.

[More with this subject...]

<Prev in Thread]	Current Thread	[Next in Thread>
Returning 4K+ from a Java Stored Procedure, Creighton Kirkendall Re: [cinjug-users] Returning 4K+ from a Java Stored Procedure, Abdul Habra <= Re: [cinjug-users] Returning 4K+ from a Java Stored Procedure, Creighton Kirkendall Re: [cinjug-users] Returning 4K+ from a Java Stored Procedure, Eric Bardes Re: [cinjug-users] Returning 4K+ from a Java Stored Procedure, santosh kaushik

Previous by Date:	Hibernate 3 on jdk 1.3, Bill Manuel
Next by Date:	Re: [cinjug-users] Returning 4K+ from a Java Stored Procedure, Creighton Kirkendall
Previous by Thread:	Returning 4K+ from a Java Stored Procedure, Creighton Kirkendall
Next by Thread:	Re: [cinjug-users] Returning 4K+ from a Java Stored Procedure, Creighton Kirkendall
Indexes:	[Date] [Thread] [Top] [All Lists]