|
-
I am having problems executing the smaple java procedure.
These are the steps I followed.
SQL> CREATE OR REPLACE JAVA SOURCE NAMED "Echotest" AS
2 public class Echotest { public static void main (String[] args) {
3 for (int i=0; i<args.length;i++) System.out.println(args[i]);}}
4 /
Java created.
SQL> create or replace procedure echo_test (
2 s1 varchar2, s2 varchar2, s3 varchar2)
3 as language Java
4 name 'Echotest.main(java.lang.String[])';
5 /
Procedure created.
SQL>
SQL> call dbms_java.set_output(5000);
call dbms_java.set_output(5000)
*
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
java.security.AccessControlException: the Permission
(java.util.PropertyPermission line.separator read) has not been granted by
dbms_java.grant_permission to SchemaProtectionDomain(SYS|PolicyTableProxy(SYS))
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|