Re: Java classes

joker197cinque_at_gmail.com wrote:
> I'm trying to register a java class this way:
>
> CREATE JAVA CLASS USING BFILE (java_dir, 'Agent.class')
>
> where java_dir is a directory created this way:
>
> CREATE DIRECTORY JAVA_DIR AS 'C:\bin';
>
> Executing these 2 commands is succesfully, but when I try to expand
> "Java sources" in PL/SQL Developer or when I query "dba_java_classes" I
> cannot locate Agent.class anywhere...
>

Try the following query
SQL> col DBMS_JAVA.SHORTNAME(OBJECT_NAME) format a40 SQL> select dbms_java.shortname(object_name), object_type, status

          from user_objects
          where object_type not in ('TABLE', 'VIEW', 'INDEX')
          and dbms_java.shortname(object_name) like '%LongNameSample'
           order by dbms_java.shortname(object_name);

> Also, I'm searching all morning about an example that can show me how
> to process a double array Java output into a oracle collection...just
> getting crazy :-(
>
> Any help much appreciated

Look at "JDBC Support for User-Defined Collections" in section 8.2.11 of my book.
>
> Best regards.
Received on Tue Dec 05 2006 - 11:35:03 CST