Re: dropping java class

  • From: "Richard Ji" <richard.c.ji@xxxxxxxxx>
  • To: JDunn@xxxxxxxxx
  • Date: Mon, 2 Apr 2007 16:10:08 -0400

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?




Other related posts: