Creating PL/SQL procedure from Java

Hi there,

i have to create a PL/SQL procedure from my Java code. If i execute the code by connecting via JDBC to the Oracle 8.1.7. database, all works fine:

For example,
I do a stmt.execute("CREATE OR REPLACE FUNCTION getCalcul RETURN VARCHAR2 IS calcul VARCHAR2(2000); BEGIN calcul := 'Toto'; RETURN calcul; END;");

Now i put the Java code inside the database via "loadjava" and connect with the default connection. Other SQL queries still work fine.

When i execute the creation of my PL/SQL procedure, i get the following exception:

BadExecuteException: Can't executeUpdate query-ORA-14552: DDL operation, COMMIT or ROLLBACK not allowed in an DML instruction.

What's the clue here?
Should'nt i use Statement.execute() but other things instead?

Regards,
Wolf. Received on Thu Aug 01 2002 - 14:20:57 CDT