Re: Java classes

kuassi.mensah_at_gmail.com wrote:
> 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);
>

Hmm... Have you tried this query yourself? ;) 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 - 13:55:33 CST