[Dica] Função - Testa conexão

[dr_gori]

Esta função testa se a conexão está ok!

Selecionar tudo

FUNCTION NotLoggedOn RETURN boolean IS
  Dummy varchar2(1);
BEGIN
  select 'x' into dummy from dual;
  return FALSE;
EXCEPTION
  when OTHERS then
    if SQLCODE in (-1012, -- Not logged on
    	           -28,   -- Your session has been killed
    	           -3114  -- Not connected to ORACLE
    	           ) then
      return TRUE;
    end if;
    raise;
END;