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.
Hi , What is user/password to run the app?
User the code I have added to create your own username and password.
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”
.
.
.
.
.
.
thanks I got it,the source included in app