Size limit on return param from java wrapped stored proc?

[randall2nd]

Ok, Here is what I am trying to do:
I have Java app that is being called through an Oracle stored procedure wrapper

CREATE OR REPLACE FUNCTION TEST_STR( ARG IN VARCHAR2 ) RETURN VARCHAR2
AS
LANGUAGE JAVA NAME
 'testapp.longstring(java.lang.String) return java.lang.String';

now this app simply returns a string with a length of 72,000.

The procedure is executed and dumped by itself, it does not go through or into anything else that is Oracle.(hope i said that right)

My belief is that it can not do so, do to Oracle's size limit on VARCHAR2 being 32,7??.

He says that oracle is just a wrapper and has no bearing on the size that the java proc can return.

Anyway we are both very stubborn fellas and I am hoping to ping the community for deffinitive proof on this matter. Opinions are welcome, but I need factual proof either way.

Please help settle a heated debate.

Randall2nd
Ignorance does not equal stupidity, do not treat it as such.