DECLARE stat BOOLEAN; BEGIN DBMS_OUTPUT.DISABLE; DBMS_OUTPUT.ENABLE (100000); stat := fnd_profile.SAVE ('SITENAME', 'VALOR DESEJADO', 'SITE'); IF stat THEN DBMS_OUTPUT.put_line ('Stat = TRUE - profile updated'); ELSE DBMS_OUTPUT.put_line ('Stat = FALSE - profile NOT updated'); END IF; COMMIT; END;
Blog com dicas, scripts, How-to para DBA´s e Desenvolvedores ORACLE.