0 Replies Latest reply: Mar 20, 2013 8:18 AM by greich RSS

    Having issues running sample app issue tracker

    greich
      Hi,

      We have installed a fresh 11g database and ran the update scripts to update to APex 4.21.

      We can sign into apex without issues, but after I installed the issue tracker sample app, I can not log in with apex credentials.

      I get the error:

      The following error has occurred while executing the error handling callback: ORA-06550: line 5, column 38: PLS-00201: identifier 'EBA_IT_FW.APEX_ERROR_HANDLING' must be declared ORA-06550: line 5, column 1: PL/SQL: Statement ignored ORA-06550: line 6, column 11: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 5, column 4: PL/SQL: SQL Statement ignored ORA-06550: line 9, column 7: PLS-00364: loop index variable 'C1' use is invalid ORA-06550: line 9, column 4: PL/SQL: Statement ignored


      Technical Info (only visible for developers)
      •is_internal_error: false
      •ora_sqlcode: -6550
      •ora_sqlerrm: ORA-06550: line 6, column 11: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 5, column 4: PL/SQL: SQL Statement ignored ORA-06550: line 9, column 7: PLS-00364: loop index variable 'C1' use is invalid ORA-06550: line 9, column 4: PL/SQL: Statement ignored
      •component.type: APEX_APPLICATION_PROCESSES
      •component.id: 2551281256736928346
      •component.name: set time zone
      •error_backtrace:
      ORA-06512: at "SYS.DBMS_SYS_SQL", line 1926
      ORA-06512: at "SYS.WWV_DBMS_SQL", line 973
      ORA-06512: at "SYS.WWV_DBMS_SQL", line 999
      ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_EXEC", line 830
      ORA-06512: at "APEX_040200.WWV_FLOW_PROCESS", line 138


      I'm guessing this is a priveldge issue. can anyone help?

      Thanks