JDBC question: Execute procedure with plain SQL?

Hi all.

    I know that PreparedStatements are the correct means for executing a stored procedure, but in my current case I am limited to a plain Statement object. Is there a SQL string that would allow a plain statement to execute a simple non-parameterized procedure? Eg:

Statement s = con.createStatement();
s.execute("execute myProcedureName" );

This doesn't work like SQL-PLUS... The driver just sends the "execute myProcedureName" to the DBMS and then it fails with a ORA-00900: invalid SQL statement.

Thanks,
Joe Weinstein at BEA Received on Tue Mar 29 2005 - 10:38:36 CST