Folks,
Anyone know if it's possible to pass a package record type as a parameter
to a Java stored procedure?
e.g.,
create or replace package el_zip_pkg
is
type file_rec_type is record (
name varchar2(255)
, data blob
);
type file_rec_list_type is table of file_rec_type;
procedure create_zip_file( zip_file_name varchar2(255), files
file_rec_list_type );
end el_zip_pkg;
create or replace package body el_zip_pkg
is
procedure create_zip_file( zip_file_name varchar2(255), files
file_rec_list_type )
is
language java
name 'com.maximus.hf.utils.Zipper.createZipFile( java.lang.String,
oracle.sql.ARRAY )';
end el_zip_pkg;
This fails, complaining that a non-schema record type cannot be passed to
a Java routine.
So, I'm using object types, but I can't embed these within the package --
I preferred to keep this structure packaged within its own namespace,
rather than relying on additional types within the calling user's schema.
Any workarounds? Am I missing something obvious?
Adam
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
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).
