SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00900: invalid SQL statement

user576522Sep 12 2007 — edited Sep 12 2007

Hi, .
I have a stored procedure in PLSQL, it is valid and works well in plsql. But when I call it from JAVA by CallabelStatement, it throws errors:

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

	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
	at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:212)
	at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:951)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3390)
	at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4223)
	at query.NetworkRangeQuery.getLinkNodeCoverPoint(NetworkRangeQuery.java:68)
	at query.NetworkRangeQuery.query(NetworkRangeQuery.java:150)
	at query.NetworkRangeQuery.main(NetworkRangeQuery.java:186)[\PRE]

may someone help me pls? thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 10 2007

Added on Sep 12 2007

3 comments

1,019 views