Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    Dale i Sunnfjord
    Posts
    8

    Unanswered: 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?

    -aj

  2. #2
    Join Date
    Aug 2003
    Location
    Dale i Sunnfjord
    Posts
    8

    Re: Receive java.io.InputStream frm PL/SQL

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •