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