SELECT status FROM user_objects (JAVA CLASS Query)

Hello, a quick query.

When I execute the following SQL command I get information about tables, functions, indexes, operators etc and whether they are in a valid state.

SELECT object_name, object_type, status, timestamp

    FROM user_objects ORDER BY object_type, object_name;

Using DBA Studio I can 'see' details on all the tables, functions, indexes, operators etc.

What I can't see is information on the type "JAVA CLASS". I have a "JAVA CLASS" in an "INVALID" state according to the above SQL. I need to track this state invalidity down further but to my surprise can't find information for the object in DBA Studio.

Any pointers please?

Spencer

• 0 - 0 - 0 -

If I haven't been clear enough in explaining the query, follow the steps below (assuming Win environment)

1. Open Notepad
2. Paste the following code into the blank document

   public class fred
   {
    int i=1;
   }

3. At the command line type

   javac fred.java

4. At the command line type

   loadjava -user scott/tiger fred.class

5. Open SQL+ and type in the following SQL

   SELECT object_name, object_type, status, timestamp      FROM user_objects ORDER BY object_type, object_name;

6. fred should be there, as a "JAVA CLASS", and in an invalid state.

So where in DBA studio can I examine this objects properties? Received on Thu Jul 11 2002 - 03:08:42 CDT