Oracle APEX template application

The first setup of an application is always a time consuming activity. To reduce that for all APEX developers I have create a template application with custom login functions.

The package includes all tables and functions you need to up and run you complete APEX application with a few clicks.

You can download the complete app

https://github.com/apex-base/orclapex

User the below code to get your own username en password

declare
 
 l_user_name varchar2(100);
 l_user_pwd varchar2(100);
 
 begin
 l_user_name :='admin@apex-base.com';
 l_user_pwd := APP_SECURITY_PKG.get_hash('admin@apex-base.com','Welcome01');
 
 UPDATE app_user
 SET
 usr_name = l_user_name,
 usr_pwd = l_user_pwd
 WHERE
 usr_id = 1;

end;

 

Any question? drop a comment.

4 thoughts on “Oracle APEX template application”

  • Salam,
    When I triad to Install the application I got the following errors, it seems that all source of tables and packages are not available on Github. so please guide me where we can got these sources .
    ——————— the errors ————
    DROP TABLE “APP_ERROR_LOG”

    ORA-00942: table or view does not exist

    DROP TABLE “APP_LOGGING”

    ORA-00942: table or view does not exist

    DROP TABLE “APP_PARAMETER”
    .
    .
    .
    .
    .
    .

Leave a Reply

Your email address will not be published. Required fields are marked *