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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
