Pular para o conteúdo principal

Changing profile Java Color Scheme through plsql


sqlplus apps/apps

set serveroutput on
DECLARE
BEGIN
        dbms_output.disable;
        dbms_output.enable(100000);
        stat := FND_PROFILE.SAVE('FND_COLOR_SCHEME', 'OLIVE', '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;
/

Below, some values that you can use:

  • BLUE
  • KHAKI
  • OLIVE
  • PURPLE
  • RED
  • SWAN
  • TEAL
  • TITANIUM 

Comentários