Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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