Calling Oracle Stored Procedure from R2DBC

Question

I am trying to call an Oracle stored procedure from Spring Data R2DBC. I have currently set up querying either by annotation or R2DBC entity template and those work fine. However, I have not been able to call a proc with input/output parameters.

I saw some documentation mentioning support for procedure calls in R2DBC but have not found any concrete examples on how it is done. Any help or link to documentation or examples would be greatly appreciated.

Yes, but how do I call a procedure? Eg my_proc(input1, input2, output1) — Ryan Queenan, Aug 08 '22 at 20:55
Sorry, phone linked me to the top of the page but now seeing the procedure section. Fantastic thanks! — Ryan Queenan, Aug 08 '22 at 20:59

score 0 · Accepted Answer · answered Aug 08 '22 at 21:41

0

The documentation for how to do procedural-calls can be found in the readme on github for the oracle-r2dbc driver:

procedural calls

answered Aug 08 '22 at 21:41

Toerktumlare

12,548
3
35
54

Calling Oracle Stored Procedure from R2DBC

1 Answers1