PLSQL JAVA编程 方法一 内部编程

 

create or replace and compile java source named "javademo1"

as

import java.sql.*;

public class JavaDemo1

{

public static void main(String[] argv)

{

System.out.println("hello, java demo1");

}

}

/

show errors java source "javademo1";

create or replace procedure javademo1

as

language java name 'JavaDemo1.main(java.lang.String[])';

/

set serveroutput on

call dbms_java.set_output(5000); --open java output

call javademo1();