Pass cursor to Procedure [message #682085] |
Sun, 04 October 2020 14:19 |
ora9a
Messages: 42 Registered: June 2010
|
Member |
|
|
Hi,
I have a requirement to take in a list of values passed in from a logic app in Azure, and use that list in a where clause, and return the results.
The values passed in will be codes such as 'EP-L200-20044-21', 'EL-B910-20077-21'
CREATE TABLE IA_TEST (COL1 VARCHAR2(20));
CREATE OR REPLACE PROCEDURE IA_TEST_PROC (P_LIST IN SYS_REFCURSOR, P_OUTPUT OUT SYS_REFCURSOR ) AS
BEGIN
OPEN
p_output
FOR
SELECT COL1
FROM IA_TEST
WHERE COL1 IN (P_LIST);
END;
This proc will not work, but what is the best way to achieve this?
thanks guys.
|
|
|
|
|
|
|
|