错误提示1:identifier 'DBMS_JAVA.GRANT_PERMISSION' must be declared附原代码:
beginDbms_Java.Grant_Permission('DBSNMP',
'java.io.FilePermission', '<<ALL FILE>>',
'read ,write, execute, delete');Dbms_Java.Grant_Permission('hr',
'java.io.FilePermission', 'd:aa.bat',
'read ,write, execute, delete'); dbms_java.grant_permission
('hr',
'java.lang.RuntimePermission',
'*',
'writeFileDescriptor' );
end;
/
============错误提示2:ORA-29547: Java system class not available: oracle/aurora/rdbms/Compiler附代码:
create or replace and compile
java source named "Test"
as
import java.io.*;
import java.lang.*;
public class Util extends Object
{
public static int RunThis(String args)
{
Runtime rt = Runtime.getRuntime();
int rc = -1;
try
{
Process p = rt.exec(args);
int bufSize = 4096;
BufferedInputStream bis =
new BufferedInputStream(p.getInputStream(), bufSize);
int len;
byte buffer[] = new byte[bufSize];
// Echo back what the program spit out
while ((len = bis.read(buffer, 0, bufSize)) != -1)
System.out.write(buffer, 0, len);
rc = p.waitFor();
}
catch (Exception e)
{
e.printStackTrace();
rc = -1;
}
finally
{
return rc;
}
}
}
请高手指点!初学oracle开发
beginDbms_Java.Grant_Permission('DBSNMP',
'java.io.FilePermission', '<<ALL FILE>>',
'read ,write, execute, delete');Dbms_Java.Grant_Permission('hr',
'java.io.FilePermission', 'd:aa.bat',
'read ,write, execute, delete'); dbms_java.grant_permission
('hr',
'java.lang.RuntimePermission',
'*',
'writeFileDescriptor' );
end;
/
============错误提示2:ORA-29547: Java system class not available: oracle/aurora/rdbms/Compiler附代码:
create or replace and compile
java source named "Test"
as
import java.io.*;
import java.lang.*;
public class Util extends Object
{
public static int RunThis(String args)
{
Runtime rt = Runtime.getRuntime();
int rc = -1;
try
{
Process p = rt.exec(args);
int bufSize = 4096;
BufferedInputStream bis =
new BufferedInputStream(p.getInputStream(), bufSize);
int len;
byte buffer[] = new byte[bufSize];
// Echo back what the program spit out
while ((len = bis.read(buffer, 0, bufSize)) != -1)
System.out.write(buffer, 0, len);
rc = p.waitFor();
}
catch (Exception e)
{
e.printStackTrace();
rc = -1;
}
finally
{
return rc;
}
}
}
请高手指点!初学oracle开发
解决方案 »
- WIN7 64位 + Toad for oracle 11.6 64b + oracle client 11.2 64b 配置成功
- 报错求教reached maximum ASM file size (16384 GB)
- 系统重装后如何恢复Oracle10g数据库
- 很简单的问题,希望大家帮帮忙
- sql plus 的用户名、口令和主机字符串填什么啊?
- Oracle全文检索中遇到特殊字符的问题
- Oracle数据库中图像的存储与操作的问题
- 新手求救
- 大家来谈论一下回滚段表空间的问题
- 这个程序的错误在哪里?大家帮忙!
- 数据库链问题
- oracle 动态执行的sql语句中, insert into 中用多个union all 连接出来的语句效率高, 还是把union all分成多个insert into 效率高呢, 为什么?
如果是运行到那个数据库语句,请直接帖出该sql语句或存储过程或函数出来代码出来