PL/SQL client for Sentry
- Get the code: git clone git://github.com/teopost/raven-plsql
- Connect to Oracle Database
- Enable Oracle ACL for remote connection
- Cut & Paste stored procedure into oracle schema
Connect to Oracle sys user, replace ORACLE_SCHEMA with your Oracle schema name and execute script.
/* Create ACL for user ORACLE_SCHEMA */
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (
acl => 'raven-plsql.xml',
description => 'Acl for sentry service',
principal => 'ORACLE_SCHEMA',
is_grant => true,
privilege => 'connect');
commit;
END;
/
/* Add privilege of ACL to user ORACLE_SCHEMA */
BEGIN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE
(acl => 'raven-plsql.xml', principal => 'ORACLE_SCHEMA',is_grant => true, privilege => 'resolve');
commit;
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL
(acl => 'raven-plsql.xml', host => 'sentry.apexnet.it');
commit;
END;
/
exec RavenClient('app.getsentry.com/api/29639', 'cff7fad696c346e8966d0b0c82439df8', '79df31b6aa9642a3bef837f21f4132f1', 'This is a test', 'fatal')
Note: Use http://sentry.apexnet.it/api/12 only for WEDO internal Sentry server
http://www.oracleflash.com/36/Oracle-11g-Access-Control-List-for-External-Network-Services.html http://sentry.readthedocs.org/en/latest/developer/client/index.html