Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> calling java from Oracle 8i stored prcedure security problem
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 Thu Aug 24 2000 - 11:13:33 CDT
![]() |
![]() |