Hi,

I need to create a program that sets up the necessary server code
in the database by running various scripts. It now works for all
objects
except JAVA SOURCE objects.


The following sample code in VFP/VB
lcsql='create or replace and compile java source named
DeleteFile'+chr(10)
lcsql=lcsql+'as'+chr(10)
lcsql=lcsql+'import java.io.*;'+chr(10)
lcsql=lcsql+'public class DeleteFile'+chr(10)
lcsql=lcsql+' {'+chr(10)
lcsql=lcsql+' public static void DoDelete(String FilePath) throws
Exception'+chr(10)
lcsql=lcsql+' {'+chr(10)
lcsql=lcsql+' File NewFile = new File(FilePath);'+chr(10)
lcsql=lcsql+' NewFile.delete();'+chr(10)
lcsql=lcsql+' }'+chr(10)
lcsql=lcsql+' }'+chr(10)
**lcsql=lcsql+'/'+chr(10)

lnerror=SQLEXEC(h,lcsql)
IF lnerror=-1
?MESSAGE()
ENDIF

Give the error:
Connectivity error: [Oracle][ODBC][Ora]ORA-29542: class DeleteFile
already defined by source DeleteFile


However, Running the same code in sqlplus:
SQL> create or replace and compile java source named "DeleteFile"
2 as
3 import java.io.*;
4
5 public class DeleteFile
6 {
7 public static void DoDelete(String FilePath) throws Exception
8 {
9 //Delete FilePath
10 File NewFile = new File(FilePath);
11 NewFile.delete();
12 }
13 }
14 /

Java created.

Works fine...


I'm a little confused about the error message and confess I cant seem
to figure out how to find this "already defined source"?

Does anyone have any ideas here?

On 5 Jul 2003 03:22:53 -0700, tjm (AT) runtime (DOT) dk (TimMcConechy) wrote:


Use a proper development environment. Do not use ODBC when you can use
sql*plus. Do NOT allow end-users to misuse ODBC to create any object
on the fly


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

Thanks for the reply..

The purpose of this part of the application is to run scripts
I know sqlplus can do this but the boss wants it in this application.
I understand your point and will take it under advisment.
Any reason for this position? (I understand the security
consequences).

Can SQLPLUS by made to run in silent mode?

Programs like Toad seem to be able to run it and I dont see you
complaining to them about not using sqlplus.

If anyone has any ideas about the original problem I would still
appreciate it.

BR
Tim