Kindly explain how to call Stored procedure in JDBC query consumer

asked 2019-05-10 01:37:38 -0500

soumya.sujith gravatar image

I tried calling stored procedure in JDBC query consumer and I am getting the below error.

JDBC_34 - Query failed to execute: 'EXEC SAMPLEDBO.PKG_SAMPLE.PROCESS_TEST('ABCD')' Error: SQLState: 42000 Error Code: 900 Message: ORA-00900: invalid SQL statement

I tried with 'CALL SAMPLEDBO.PKG_SAMPLE.PROCESS_TEST('ABCD')'. Still getting error

Is there any other stage from which we can call stored procedure.

edit retag flag offensive close merge delete

Comments

Which mode have you configured for the JDBC Query Consumer? Full or incremental?

metadaddy gravatar imagemetadaddy ( 2019-05-14 10:35:17 -0500 )edit