Re: Java classes

Vladimir M. Zakharychev wrote:
>> Hmm... Have you tried this query yourself? ;)

Yes indeed, see the query and the return in section 2.1.9 in my book fwiw, here is the script for creating the java class

SQL>CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED LongNameSample AS package longnamepkg.subpackage.foo;
class LongNameSample {
public static void main (String argv[]) { System.out.println ("Hello LngNameSample"); }
}
/

>You probably meant something like this:
>
> col java_short_name format a30
> select
> dbms_java.shortname(object_name) java_short_name
> ,object_type
> ,status
> from user_objects
> where object_type like 'JAVA%'
> and dbms_java.LONGNAME(object_name) = 'my/package/MyClassName'
> -- alternatively:
> -- and dbms_java.longname(object_name) like '%MyClassName'
>
> Regards,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com
Received on Tue Dec 05 2006 - 15:48:32 CST