I am wondering how to recieve a stream of data from pl/sql to a java-class stored in the database.

Right now my plan is to pass a LOB to java and treat it as an InputStream, but I am not sure if it is possible.

Is it anyone here who knows?

-aj

I found out myself!!!!!

If anyone has the same problem:

First create a temporary CLOB in PL/SQL and fill it with the data you need to stream.

This CLOB can be passed directly to the java-class via a java-wrapper. Use the datatype java.sql.Clob

In your java-method you receive an InputStream from the CLOB by calling the method getAsciiStream() on the Clob-object