PL/SQL (MOSC)

MOSC Banner

How to publishing JAVA class into Oracle PL/SQL?

edited Nov 12, 2013 5:51AM in PL/SQL (MOSC) 3 commentsAnswered
Hi Oracle,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center