Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Returning a Java object to PL/SQL
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
![]() |
![]() |