How to publishing JAVA class into Oracle PL/SQL?
I have a Java class file, Lines.class. It has stored in Oracle database (11.2.0.3), by loadjava commend.
I could not public it on PL/SQL function. Please advise me. Thanks.
SQL> CREATE OR REPLACE FUNCTION my_test RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'Lines() return javax.servlet.http.HttpServlet';
2 /
Warning: Function created with compilation errors.
SQL> CREATE OR REPLACE FUNCTION my_test RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'Lines() return java.lang.Object';
2 /
Warning: Function created with compilation errors.
SQL> CREATE OR REPLACE FUNCTION my_test RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'Lines() return java.lang.String';
2 /
Warning: Function created with compilation errors.