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

Its configured as Full Mode. I am able to execute the stored procedure from JDBC Query executor.But I need the response back, which is not possible there. how can we call the stored procedure with OUT parameter

soumya.sujith gravatar imagesoumya.sujith ( 2019-05-23 06:26:59 -0500 )edit