Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Java PL/SQL Procedure

Status
Not open for further replies.

engineer2100

Programmer
Joined
Feb 7, 2002
Messages
285
Location
US
I am just aware of this as of now.. but a simple query resolution could convert this statement to "I know this...."

Code:
public class Ex{

   public static String foo(String arg, String[] outArg){

      // do something useful with arg

      // and return some String

   }

}

CREATE FUNCTION ORA_FOO(VARCHAR2 IN ARG, VARCHAR2 OUT OUT_ARG) RETURN VARCHAR2 AS LANGUAGE JAVA NAME ‘Ex.foo(java.lang.String, java.lang.String[]) return java.lang.String’;

Query: Where should this Class Ex be compiled and stored?

-Engi
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top