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

    Unanswered: Recieve java.io.InputStream from PL/SQL

    I need to send a stream of data to a method in a java-class from pl/sql.

    Does anybody know how to do this??? What datatypes should I use in pl/sql?

    I am thankful if anybody could help me


    -aj

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

    Re: Recieve java.io.InputStream from 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
  •