rami.info

To run java code from oracle do the following:

1. Create the java code on the server:

CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "hello" AS
public class hello {
public static String world() {
return "Hello World";
}
}
/

2. Create the oracle function on the server:

CREATE OR REPLACE FUNCTION hellofunction RETURN VARCHAR2 AS
LANGUAGE JAVA NAME 'hello.world() return java.lang.String';
/

3. Call the function using a SELECT:

SELECT hellofunction() from DUAL;

Update root.cache or named.ca files for DNS servers using the following command:

dig @a.root-servers.net. . ns

UPDATE: a better command:

dig +bufsize=1200 +norec NS . @a.root-servers.net > /var/named/named.root [Link]


And it’s from my wife :o)