Ask Your Question

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


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

Can you explain how you resolved this..I am also facing the same issue

Arnab_Singha gravatar imageArnab_Singha ( 2020-08-03 05:06:32 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2020-08-03 09:17:03 -0500

iamontheinet gravatar image


This is how you call a stored procedure from JDBC Query Consumer origin.

image description

image description

Cheers, Dash

edit flag offensive delete link more


Thanks Dash I am using JDBC Query Executor to call a stored procedure that has an output parameter. Can you explain how to extract a single output varchar from the procedure

Arnab_Singha gravatar imageArnab_Singha ( 2020-08-04 02:35:00 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 424 times

Last updated: 2 days ago