...
Bloco de código | ||||||
---|---|---|---|---|---|---|
| ||||||
--Procedure
CREATE OR REPLACE PROCEDURE sp_kill_session(p_sid NUMBER, p_serial NUMBER, inst_id NUMBER)
as
BEGIN
EXECUTE IMMEDIATE 'ALTER SYSTEM KILL SESSION '''||p_sid||','||p_serial||','||'@'||inst_id||''' IMMEDIATE';
EXCEPTION
WHEN OTHERS THEN
RAISE_APPLICATION_ERROR(-20000, sqlerrm);
END sp_kill_session;
/
--Criação do sinônimo
CREATE SYNONYM consinco.sp_kill_session
FOR sys.sp_kill_session;
--Grant na procedure
grant execute on sys.sp_kill_session to consinco; |
...