自己对oracle不太了解
触发器|||||||
create or replace trigger Test
after insert on tab_caplog
for each row
declare
ID number;
begin
select sendmsg(:new.id) into ID from dual;
end Test;java|||||||create or replace and compile java source named testclient as
import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.io.OutputStreamWriter;
import java.io.PrintWriter;
import java.net.Socket;public class TestClient { public static int sendMes(int msg) {
int rmsg = 0;
try {
Socket client = new Socket("127.0.0.1", 9999);
BufferedReader br = new BufferedReader(new InputStreamReader(client
.getInputStream()));
PrintWriter out = new PrintWriter(new OutputStreamWriter(client
.getOutputStream(), "GBK"), true);
out.println(msg);
out.flush();
rmsg = Integer.parseInt(br.readLine());
System.out.println(rmsg);
client.close();
} catch (Exception e) {
System.out.println(e.getMessage());
}
return rmsg;
}
}函数|||||create or replace function sendMsg(name number) return number as
language java name 'TestClient.sendMes(java.lang.Integer)return java.lang.Integer';报错|||||
ORA-29531: 没有方法sendMes在类TestClient中
ORA-06512: 在"ZHAOHUAN.TEST", line 4
ORA-04088: 触发器 'ZHAOHUAN.TEST' 执行过程中出错
帮忙给看一下吧。
触发器|||||||
create or replace trigger Test
after insert on tab_caplog
for each row
declare
ID number;
begin
select sendmsg(:new.id) into ID from dual;
end Test;java|||||||create or replace and compile java source named testclient as
import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.io.OutputStreamWriter;
import java.io.PrintWriter;
import java.net.Socket;public class TestClient { public static int sendMes(int msg) {
int rmsg = 0;
try {
Socket client = new Socket("127.0.0.1", 9999);
BufferedReader br = new BufferedReader(new InputStreamReader(client
.getInputStream()));
PrintWriter out = new PrintWriter(new OutputStreamWriter(client
.getOutputStream(), "GBK"), true);
out.println(msg);
out.flush();
rmsg = Integer.parseInt(br.readLine());
System.out.println(rmsg);
client.close();
} catch (Exception e) {
System.out.println(e.getMessage());
}
return rmsg;
}
}函数|||||create or replace function sendMsg(name number) return number as
language java name 'TestClient.sendMes(java.lang.Integer)return java.lang.Integer';报错|||||
ORA-29531: 没有方法sendMes在类TestClient中
ORA-06512: 在"ZHAOHUAN.TEST", line 4
ORA-04088: 触发器 'ZHAOHUAN.TEST' 执行过程中出错
帮忙给看一下吧。
解决方案 »
- 学oracleDBA是不是要从数据库开发做起呀?
- 如何在MFC里使用oo4o
- ORA有没有事件探查器来监视程序对ORA数据库 的操作活动??
- [高分提问] 因为 OLE DB 提供程序 'MSDAORA' 无法启动分布式事务
- 请大神帮忙 excel语言转为SQL语言
- 询问查看指定用户所拥有的数据表的命令
- 20分求sql语句,如何在一个表中查询出字段join_date(date类型)的值与某个常量如2005-1-1最接近的记录
- 关于UDUMP目录下的跟踪文件的问题?在线等。。。
- 寻求一条SQL语句,急~~~~~~
- 一个sql语句查询优化的问题
- 未找到父项关键字 怎么解决?
- 怎么将SQL SERVER中的数据导入到ORACLE中去
有没有你的类权限付了吗,需要io的权限,还有java source的权限
Socket的权限呢
exec dbms_java.grant_permission( 'user', 'SYS:java.net.SocketPermission', '*', 'connect,resolve' );