Hi, can you help me?
I need to create a cursor with table name as a variable.
Something in the following example:
DECLARE POR_ID NUMBER(10,0);
TBL_NAME_PROV VARCHAR2(100);
SMLPOR VARCHAR2(20);
BEGIN
TBL_NAME_PROV := 'TMP_PROV_5652_0_65';
--FOR SMLPOR IN (EXECUTE IMMEDIATE 'SELECT TD_SITPORADCE_ID FROM ' || TBL_NAME_PROV)
EXECUTE IMMEDIATE 'FOR SMLPOR IN (SELECT TD_SITPORADCE_ID FROM ' || TBL_NAME_PROV || ')''';
LOOP
POR_ID := SMLPOR.TD_SITPORADCE_ID;
DBMS_OUTPUT.PUT_LINE('TD_SITPORADCE_ID : = ' || POR_ID);
END LOOP;
END;
I tried a different syntax, but all did not work.
Thank you.
MV