Re: calling java from Oracle 8i stored prcedure security problem

JAVASYSPRIV harkinj_at_my-deja.com wrote:

> Hi,
> I'm attempting to call a java method from an Oracle stored procedure.
> The stored procedure is as follows.
> CREATE OR REPLACE PROCEDURE CreateJob( JobId VARCHAR2 )
> AS language Java
> name 'AreasDML.insertrow( java.lang.String )';
> /
> I'm logged in as system/manager when i run the above in sql plus.
>
> When i run the stored proecdure i get
> ORA-29532: Java call terminated by uncaught Java exception:
> java.lang.SecurityException
>
> I only get this when the java code attempts to do something like write
> to a file or connect to a URL.
> If it does nothing then everthing is fine.
>
> What do i have to do to get it working correctly ?
>
> Java Source :
>
> import java.io.*;
>
> class AreasDML
> {
> public static void
> insertrow ( String JobId)
> {
> try
> {
>
> FileWriter fw = new FileWriter("c:\\temp\\jh.tmp");
> fw.write("Hello John");
> fw.close();
>
> catch ( IOException e)
> {
> System.out.println("Error:" + e );
> }
> }
> }
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Aug 25 2000 - 17:08:14 CDT