citrusframework / citrusframework/citrus

How to call store procedure and get output parameters

Open
#721 0 comments 1 reaction 0 assignees View on GitHub
Dominant language
Java
Stars
485
Forks
155
Avg merge
2d 10h
Merged PRs (30d)
7

Description

**Citrus Version** 2.8.0

**Question** I wonder how can I call a stored procedure which has output parameters and somehow get the output parameters for verification and/or later use.

For example the following works, but what if the procedure has output parameters?
sql(action -> action.dataSource(dataSource).statement("{call procedureName('some param')}"));

**What I've tried so far**
I have searched through the samples, the documentation and Googled.

I also found https://github.com/citrusframework/citrus/issues/412 in which there is an answer referencing https://github.com/citrusframework/citrus/blob/master/modules/citrus-integration/src/it/java/com/consol/citrus/javadsl/design/ExecutePLSQLJavaIT.java so that should help, but the link does not exist at the moment.
Moreover, I found a file with the same name here https://github.com/citrusframework/citrus/blob/master/vintage/citrus-java-dsl/src/test/java/com/consol/citrus/integration/design/ExecutePLSQLJavaIT.java but that does not deal with output parameters at all.

**Additional information**

Contributor guide

Open the contributing guide

Research direction

Start by reviewing the issue 412 reference and vintage/citrus-java-dsl/src/test/java/com/consol/citrus/integration/design/ExecutePLSQLJavaIT.java, then inspect the current SQL action documentation and samples. Document or add a current example showing how stored-procedure output parameters are accessed for verification or later use.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
documentation
Issue type
Documentation
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.