Oracle Stored Procedure call

Legacy Contributor

Hi All,

I'm very new to ION so please be patient.

I have an Oracle stored procedure that returns prepared XML.

1. What is the format required to pass input parameters to a procedure?

    

2. Where can I find this document?

    Infor ION Technology Connectors Administration Guide for 12....

 

thanks

Legacy Contributor

Calling Stored Procedure from ION :

Declare a variable and set the value for it and pass it to the Stored procedure.



DECLARE @fDate datetime

SET @fDate=[dbo].[get_MSG_LastPollDate] ('usp_getOrders_v1')

EXECUTE [dbo].[usp_getOrders_v1] @fDate