Wednesday, March 28, 2012

Receive java.io.InputStream frm PL/SQL

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?
-ajI 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

No comments:

Post a Comment