APEX

Hi all,

i am working on authentication and i want to authenticate my application using Page name.

i have created some function to authenticate application and Authorization Schemes.

my Function

create or replace FUNCTION "GET_ADMIN_STATUS" (p_user_id IN varchar,p_page_name IN VARCHAR)
RETURN BOOLEAN
IS
  ins NUMBER;

BEGIN
  SELECT 1 into ins FROM USER_OBJECT_PRIV_MAS WHERE user_id = p_user_id AND object_id = (select object_id from object_mas where object_name=p_page_name) AND EXECUTE_YN='Y' AND INSERT_YN='Y';
  RETURN TRUE;
EXCEPTION
WHEN NO_DATA_FOUND THEN
  return FALSE;
END;


i have call it into Authorization Schemes

return GET_ADMIN_STATUS(:APP_USER,TO_CHAR(:APP_PAGE_NAME));

But it's not working .
i want to authenticate application using application page name.

How can i do this ?



Thanks & Regards
Vedant

Edited by: Vedant on Jul 11, 2012 11:06 PM