How to create a Java stored procedure

An example of creating a stored procedure using Java:

Create or replace and compile
Java source
Named "Mytimestamp"
As
Import java.lang.String;
Import Java.sql.Timestamp;
public class Mytimestamp
{
public static String Gettimestamp ()
{
Return (New Timestamp (System.currenttimemillis ())). ToString ();
}
};
/
Note: Pay attention to Java syntax, note the case

Create or Replace function My_timestamp return VARCHAR2
As language Java
Name ' Mytimestamp.gettimestamp () return java.lang.String ';
/

Sql>select My_timestamp,to_char (sysdate, ' yyyy-mm-dd hh24:mi:ss ') Oracle_time from dual;

My_timestamp Oracle_time

------------------------ -------------------

2003-03-17 19:15:59.688 2003-03-17 19:15:59