JDBC for creating a stored precedure

Hallo,
i try to install a stored proc to Oracle like this:

stored proc:

 create or replace package pg_mypackage as    procedure transfer_table(dummy in integer);  end pg_utl_transfer;
 /

this works fine with tools like TOAD or SQLPlus if i try to send this via a statment from java with jdbc it will not execute with Exception ORA00900:Not a SQL Statement at line 3 if i change the java sql string to (no semicolon at the end of proc decleration):

 create or replace package pg_mypackage as    procedure transfer_table(dummy in integer)  end pg_utl_transfer;

the statement will run in java, but if i look at the DB i get the error:  

  On line: 1
  PLS-00103: Fand das Symbol "END" als eines der folgenden erwartet wurde:

   ; is with authid deterministic parallel_enable as

and the package will not compile...
so: How do i provide a correct java-string to create a running stored Proc/package with a stmt.execute() - call ?

Johannes Received on Thu Jun 14 2001 - 01:32:16 CDT