1.
public class TestJava
{
public static void main (String args[])
{
System.out.println("HELLO THIS iS A JAVA PROCEDURE");
}
}
2.在控制台下输入
loadjava -user 用户名/密码@sid名 -o -v -f -r d:/TestJava.java
3.在sql下建立过程
SQL> create or replace procedure helloworld
2 as language java name 'TestJava.main(java.lang.String[])';
3 /Procedure created
4.
SQL> set serveroutput on
SQL> call DBMS_JAVA.set_output(2000)
2 /Method called
5.
SQL> execute helloworld;HELLO THIS iS A JAVA PROCEDUREPL/SQL procedure successfully completed
public class TestJava
{
public static void main (String args[])
{
System.out.println("HELLO THIS iS A JAVA PROCEDURE");
}
}
2.在控制台下输入
loadjava -user 用户名/密码@sid名 -o -v -f -r d:/TestJava.java
3.在sql下建立过程
SQL> create or replace procedure helloworld
2 as language java name 'TestJava.main(java.lang.String[])';
3 /Procedure created
4.
SQL> set serveroutput on
SQL> call DBMS_JAVA.set_output(2000)
2 /Method called
5.
SQL> execute helloworld;HELLO THIS iS A JAVA PROCEDUREPL/SQL procedure successfully completed
>loadjava -user 用户名/密码@sid名 -o -v -f -r d:/TestJava.java我在sql* plus下输入:
SQL> loadjava -user user_ycl/1@prosoft -o -v -f -r d:/TestJava.java
SP2-0734: 未知的命令开头 "loadjava -..." - 忽略了剩余的行。
SQL> 出现错误,不知道什么原因?
谢谢继续回帖!
你的意思是:把 loadjava -user user_ycl/1@prosoft -o -v -f -r d:/TestJava.java
换为 c:\ loadjava -user user_ycl/1@prosoft -o -v -f -r d:/TestJava.java
吗? 我换了,有错误
>SQL> c:\ loadjava -user user_ycl/1@prosoft -o -v -f -r d:/TestJava.java;
SP2-0023: 未找到字符串继续求助阿?
loadjava -user user_ycl/1@prosoft -o -v -f -r d:/TestJava.java