how to map String[] returned from Java sp to PL/SQL

From: Krassimir Boyanov <kboyanov_at_printrak.com>
Date: 19 Apr 2002 11:17:41 -0700
Message-ID: <15071bed.0204191017.50c8335c@posting.google.com>

Hi All,

I have a function in Java returning String[] that I want to get in my PL/SQL procedure.

Anybody having an idea what type should I use to map String[] in Oracle PL/SQL to?

For example:
In Java code I have:
static void String[] MyJavaFunc(String strPar) {

   String[] arr;
   //obtaining arr;
   return arr;
}

In PL/SQL my mapping is:

FUNCTION my_func (str_par VARCHAR2) return ?????

     AS LANGUAGE JAVA NAME
      'MyJavaClass.MyJavaFunc(java.lang.String strPar) return String[]';

MTIA,
Krassimir Received on Fri Apr 19 2002 - 13:17:41 CDT