How to solve the problem in "Bug 5680283: CALLING JAVA METHOD FROM ORACLE OBJECT ORA-932" ?
Hello,
I've the same problem defined in "Bug 5680283: CALLING JAVA METHOD FROM ORACLE OBJECT ORA-932".
The related excerpt from the bug:
*********************************
Testcase step-by-step instructions:
----------------------------------
1. create the stutest.java as below
public class stutest
{public void xxx()
{ int a = 1;
}
}
2. loadjava -user scott/tiger1@graiano-pc:1521:orcl102 -thin
\SR\5979808.992\stutest.java
3. CREATE OR REPLACE TYPE stutest AS OBJECT
(dummy varchar2(1),
member procedure xxx as
LANGUAGE java
NAME 'stutest.xxx()')
/
DECLARE
s stutest;
BEGIN
NULL;
s := stutest ('1');
s.xxx ();
END;
/
*********************************
s.xxx() returns "
ORA-00932: inconsistent datatypes....".
The bug ends with:
*********************************
A member method always has an implicit parameter, SELF, of the object type.