1、操作系统:Windows 2000 Server |
2、数 据 库:Oracle 8i R2 (8.1.7) for NT 企业版 |
public s
| tatic void main (String args
| [])
|
Syst
| em.out.println("HELLO THIS i
| S A JAVA PROCEDURE");
|
4、 SQL> conn system/manager |
SQL> grant create any directory to scott; |
SQL> create or replace directory test_dir as 'd:/'; |
SQL> create or replace java class using bfile(test_dir,'TEST.CLASS') |
SQL> select object_name,object_type,STATUS from user_objects; |
SQL> create or replace procedure test_java |
name 'TEST.main
| (java.lang.String[])';
|
SQL> set serveroutput on size 5000 |
SQL> call dbms_java.set_output(5000); |
HELLO THIS iS A JAVA PROCEDURE |
HELLO THIS iS A JAVA PROCEDURE |
|