HI ALl,
I am trying to ceate a stored procedure where I need to make use of CTE as well. I am providing a skeleton below.
CREATE OR REPLACE PROCEDURE "MY_TEST"
BEGIN
WITH CTE1 AS
(
.........................
),
CTE2 AS
(
........ -- Using CTE1 here
),
CTE3 AS
(
..... -- Using CTE1 and CTE2 here
)
Update Statement1 --using CTE3 and CTE1
Update Statement2 --using CTE3 here
Update Statement3 --using CTE3 here
I am running into an issue with error "AN INTO CLAUSE IS EXPECTED IN SELECT". I am not sure how should I make use of INTO clause in this scenario.