Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Returning a Java object to PL/SQL

Returning a Java object to PL/SQL

From: Mirsky, Greg <gmirsky_at_Estee.com>
Date: Tue, 17 Dec 2002 08:58:45 -0800
Message-ID: <F001.0051B51E.20021217085845@fatcity.com>


I'm on Oracle 9iR2 and after crawling through the documentation I am beginning to think this can not be done.

Can your return a Java object back to a PL/SQL procedure/package?

I have a class that has a method that will return an extended version of
"java.io.FileOutputStream". I won't need to do anything with the object in
the PL/SQL except to pass it to another Java method along with some data obtained and manipulated from the PL/SQL procedure. The java object would be used as you would utilize "file_type" in sys.utl_file as a file pointer. Creating a Java method that would take as input a SQL results set and then make the calls to the other Java methods and handling the
"java.io.FileOutputStream" object for me is probably out of the question
since I am most likely going to be forced to deal with dynamic SQL. Anyone have suggestions, or condolences? ;-)

greg

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mirsky, Greg
  INET: gmirsky_at_Estee.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Tue Dec 17 2002 - 10:58:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US