Unable to Fetch Distinct Values using For loop and Cursor in SAP HANA.

I am trying to fetch Distinct values into the For loop in SAP HANA using CURSOR and For Loop and I am not getting all the distinct values into the For Loop. Instead of getting 10 distinct names, I am getting only 5 names in my output. Could you please guide me with the correct SQL?

CREATE PROCEDURE DBADMIN.FetchDistinctStrings()
LANGUAGE SQLSCRIPT
AS
BEGIN
        DECLARE STRING1 VARCHAR(255);
        DECLARE CURSOR MyTenIDFetch (STRING1 VARCHAR(255)) FOR
        SELECT DISTINCT EMPLOYEE_NAMES FROM "H_CPO_MAIN"."TABLE_NURO";
        OPEN MyTenIDFetch(:STRING1);
        FETCH MyTenIDFetch INTO STRING1;
        FOR CUR_ROW AS MyTenIDFetch(STRING1) DO
        SELECT STRING1 as STRING_NAMES FROM DUMMY;
        END FOR;
    CLOSE MyTenIDFetch;
END;

 

Scroll to Top