USER_NAME    EXTERNAL_IDENTITY    IS_SAML_ENABLED.
JDOE          JDOE@aol.com        TRUE
JDOE1         JDOE1@mail.com      FALSE
JDOE2         JDOE@aol.com        FALSE

PROCEDURE "<SCHEMA>"."<add_saml>" ( )
LANGUAGE SQLSCRIPT
SQL SECURITY INVOKER
AS
i INTEGER;
row_count INTEGER;
loop_current_SQL NVARCHAR(200);
valid_SAML NVARCHAR(5);
BEGIN
it_no_saml_users = SELECT DISTINCT
A."USER_NAME",A."IS_SAML_ENABLED",A."CREATOR"
FROM "SYS"."USERS" A
LEFT OUTER JOIN "SYS"."SAML_USER_MAPPINGS" B
ON (A."USER_NAME" = B."USER_NAME")
WHERE B."USER_NAME" IS NULL and A."CREATOR"='ADM' and
A."IS_SAML_ENABLED"='FALSE';
SELECT COUNT("USER_NAME") into row_count FROM :it_no_saml_users;
FOR i IN 0 .. :row_count -1 DO
SELECT "IS_SAML_ENABLED"
into valid_SAML FROM :it_no_saml_users
LIMIT 1 OFFSET :i;
IF :valid_SAML IS NULL THEN
SELECT 'ALTER USER' || "USER_NAME" || 'ENABLE SAML'
INTO loop_current_SQL
FROM :it_no_saml_users;
EXEC(:loop_current_SQL);
END IF;
END FOR;
END