Hi All,
In our application they had implemented Authentication Schema like as mentioned below
Name: OAM_HTTP_AUTHSCHEME
Schema Type: HTTP Header Variable
HTTP Header Variable Name: HTTP_OAM_REMOTE_USER
Action if Username is Empty: Redirect to Built-In URL
Verify username: Each Request
Now under Source we have option as PL/SQL where i want use below logic but throwing error as
Query logic used to implemented
declare
lv_from_email_id varchar2(4000);
begin
lv_from_email_id := null;
select distinct email_address into lv_from_email_id from email_table where lower(USER_INTRANET_ID)=lower(:APP_USER);
exception when no_data_found
then
apex_error.add_error (
p_message => '<span style="color:red"> No access exists</span>',
p_display_location => apex_error.c_inline_in_notification );
end;
but below error was got unable to get what was cauing problem.
ORA-06550: line 3, column 1: PLS-00103: Encountered the symbol "DECLARE" when expecting one of the following: begin function pragma procedure subtype type <an identifier> <a double-quoted delimited-identifier> current cursor delete exists prior The symbol "begin" was substituted for "DECLARE" to continue. ORA-06550: line 18, column 21: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: ( begin case declare end exception exit for goto if loop mod null pragma
Can some one help me here.
Regards,
Sruthitamiri