how to pass text longer than 32K to a Java Stored Procedure from a client

Hi,
I'm trying to pass text (XML) longer than the 32K PL-SQL limit to a java Stored Procedure (that will process the data and insert it appropiately) with no success so far. I'm using Oracle 8.1.7. I'm using a client that invokes the java stored procedure and pass the text as an argument. I tried having a String as the argument but I run into the 32K limit. I've been trying with streams as parameters also but I cannot make it work. For instance, when I set a java stored procedure parameter as any kind of stream, JDeveloper won't publish that method.

My question is how could it be possible to pass text longer than 32K to the Stored Procedure so this one can then process the text? Notice that I don't want to insert directly the text on a table but process it first within the Java Stored Procedure.

Thanks.
- Jose Angel -
junk_at_teleline.es Received on Wed Jan 23 2002 - 16:47:57 CST