John, You need to use dbms_java.longname(object_name) to get the full name. Richard On 4/2/07, John Dunn <JDunn@xxxxxxxxx> 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?