Re: dropping java class

John,

You need to use dbms_java.longname(object_name) to get the full name.

Richard

On 4/2/07, John Dunn <JDunn_at_sefas.com> wrote:
>
> I do a select from all_objects to get a list of database objects to drop
>
> For java classes I get something like
>
>
> DROP JAVA CLASS MYSCHEMA./f3f4f7ab_PatternParser;
> and when I run that I get an error
>
>
> ORA-29501: invalid or missing Java source, class, or resource name
>
> How do I drop these objects?
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l