I have EBSR12.2 running & I want to put my Java class on the server.
I want to call this Java class from PL/SQL Package from the database, but facing issue with error message “class does not exists”.
What I did so far is:
- Created Java class on the server under JAVA_TOP/custom
- Ran "loadjava" command
- Ran adcgnjar command
- Bounced the instance
- Created Function in DB as below
CREATE OR REPLACE FUNCTION getFees RETURN VARCHAR2 AS
LANGUAGE JAVA NAME 'XYZgetFee.getFee() return java.lang.String';
/
Now running below anonymous block, where I am getting the error message as “ORA-29540: class XYZgetFee does not exist”
================================
DECLARE
result varchar2(100);
BEGIN
result := getFees;
DBMS_OUTPUT.PUT_LINE('Sum: ' || result);
END;
================================
Please suggest.