According to https://community.boomi.com/docs/DOC-1141#jive_content_id_How_can_I_call_a_Stored_Procedure a Map Function SQL loopup should be used to access Output Parameters from a stored procedure. However, I get an error when performing the lookup (presumably because I cannot define one of the out parameters as a ref cursor (which should be empty)):
The stored procedure called is described in further detail below:
PROCEDURE Export_To_Project(Parm_Transmission_Commit IN NUMBER,
Parm_Transmission_Commit_Ok OUT NUMBER,
Parm_Rows_Found OUT NUMBER,
Parm_Ref_Data OUT Ref_Cursor_Project)
The procedure is multi-purpose:
- If called with no input parameter, data is returned through the ref cursor. This is working through a database connector. (However, if no cursor is returned due to no rows being found, the process fails).
- If called with the input parameter (Parm_Transmission_Commit), the rows are committed and a status is returned (Parm_Transmission_Commit_Ok).
It is purpose 2. that is causing problems.
Any help is appreciated, thank you.