Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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++;
}
}
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