Oracle programming using Java Source

Oracle programming using Java Source

Step 1: create java source [java] create or replace and compile java source named Hello as public class Hello {public static void run () {System. out. println ("hello world !! ") ;}} Step 2: edit the stored procedure [SQL] create or replace procedure P_RUN_HELLO as language java name' Hello. run () '; Step 3: set pl SQL pluse [html] SQL> set serveroutput on size 5000; SQL> call dbms_java.set_output (5000); Method called Step 4: run the stored procedure [SQL] SQL> EXEC P_RUN_HELLO; hello world !! PL/SQL procedure successfully completed SQL