Java stored procedures questions

I have some questions regarding Oracle stored procedures written in Java.

Here's a very simple test Java class i'm trying to load into the RDBMS:

public class SPTest
{

    static int num = 0;

    public static int getInt()
    {

        return num++;
    }
}

1. I get this error: $ loadjava -user <connect_string> SPTest.class Error while retrieving errors for SPTest ORA-00904: invalid column name

loadjava: 1 errors

Anyone know what's wrong? In something configured incorrectly?

2) Will Oracle "do the right thing" with the stored procedure above? In other words, is there persistency, do static variables keep their values across procedure invocations? Or does Oracle reload classes on every call to stored procedures?

3) Assuming some persistency exists, does RMI work from Java stored procedures? Can I expose a persistent object to external processes through RMI? Thanks!
-Alex Received on Mon Aug 23 1999 - 17:37:05 CDT