Skip to content

Instantly share code, notes, and snippets.

View bsurnida's full-sized avatar

Bhasker Surnida bsurnida

  • Oracle Corporation
  • Redwood Shored, San Francisco, CA.
View GitHub Profile
@billymeltdown
billymeltdown / oamPageSentry-apex3.sql
Created December 10, 2010 15:31
Zetetic's custom oamPageSentry function for APEX 3.0
CREATE OR REPLACE FUNCTION PASSPORT.oamPageSentry(pUser IN VARCHAR2 DEFAULT 'APEX_PUBLIC_USER') RETURN BOOLEAN
IS
vUsername VARCHAR2(512);
vSession NUMBER;
BEGIN
-- extract user from HTTP header
vUsername := UPPER(owa_util.get_cgi_env('REMOTE_USER'));
-- extract session id
vSession := wwv_flow_custom_auth_std.get_session_id_from_cookie;