Error at line 6 ORA-00933: SQL command not properly ended ORA-06512: at line 16
not seeing anything obvious
Error at line 6 ORA-00933: SQL command not properly ended ORA-06512: at line 16 DECLARE CURSOR PartTables IS SELECT TABLE_NAME, PARTITION_NAME, HIGH_VALUE FROM DBA_TAB_PARTITIONS where TABLE_owner in ('FDW','FDWSTG','FDW3NF') ORDER BY TABLE_NAME, PARTITION_POSITION; cur SYS_REFCURSOR; r INTEGER; highValue VARCHAR2(100); BEGIN FOR aTab IN PartTables LOOP EXECUTE IMMEDIATE 'BEGIN :ret := '||aTab.HIGH_VALUE||'; END;' USING OUT highValue; IF highValue NOT IN ('DEFAULT', 'MAXVALUE') THEN OPEN cur
0