1 2 Previous Next 20 Replies Latest reply on Apr 24, 2017 4:05 AM by Sruthi Tamiri

    Authentication Scheme error for PL/SQL code

    Sruthi Tamiri

      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



      lv_from_email_id varchar2(4000);
      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  
          apex_error.add_error (  
              p_message          => '<span style="color:red"> No access exists</span>',  
              p_display_location => apex_error.c_inline_in_notification );  


      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.




        1 2 Previous Next