Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with java stored procedure and symbolic links

Re: Problem with java stored procedure and symbolic links

From: <srivenu_at_hotmail.com>
Date: 12 Nov 2005 17:17:53 -0800
Message-ID: <1131844673.820997.191570@z14g2000cwz.googlegroups.com>

Did you upgrade your database from 8.1.6 ?

One metalink note says that the Java security has not been set properly in the database.

exec dbms_java.grant_permission ('PUBLIC', 'java.io.FilePermission', '<dir name>/*', 'write') ;

If that does not resolve the issue follow these steps. (If you have a test database try on that first)

Copy $ORACLE_HOME (8.1.6)/javavm/install/init_security.sql to a temp file.
Replace the word 'call' with 'exec' (this is a known bug in the script)

Login to the database as the SYS user
Run the modified SQL script

regards
srivenu Received on Sat Nov 12 2005 - 19:17:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US