java.sql.SQLException: ORA-00900: invalid SQL statement

[karthik Suryanarayanan]

Hi Guys,
When i try to execute a procedure from my java code i get the following error.

java.sql.SQLException: ORA-00900: invalid SQL statement

	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:187)
	at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:241)
	at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
	at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1477)
	at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:888)
	at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2030)
	at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1950)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2591)
	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:452)
	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:526)
	at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:209)

My code is as follows

CallableStatement callProc = conn.prepareCall(" { call MY_PROCEDURE}");
callProc.execute();

When i execute my procedure independently in Oracle SQL Developer , it runs fine but when i call it through Java , it fails..
Any possible reasons. I have also checked the user privileges and found it to be fine.

[karthik Suryanarayanan]

In my earlier I have posted , i have mentioned

CallableStatement callProc = conn.prepareCall(" { call MY_PROCEDURE}");  

earlier..

Sorry . Actually it was

CallableStatement callProc = conn.prepareCall(" { call MY_PROCEDURE()}");  

The issue got resolved. Thanks guys....