Re: Problem with java stored procedure and symbolic links

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