citrusframework / citrusframework/citrus
How to call store procedure and get output parameters
- 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
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