Oracle Forms to Oracle APEX Migration (Help)

  The database user for the connection pool named |apex|rt|, is not able to proxy to the schema named XXXX. This could be a configured restriction on the maximum number of database sessions or an authorization failure. Solution :-   alter user XXXXX  grant connect through APEX_REST_PUBLIC_USER;

 Signature in APEX Page  Special Thanks to Daniel Hochleitner Download Plug In:- https://github.com/Dani3lSun 1) Create Table CREATE TABLE  "SIGNATURE"     ( "COMPCD" VARCHAR2(2),  "LOCNCD" VARCHAR2(2),  "BRCD" VARCHAR2(3),  "DEPTCD" VARCHAR2(3),  "DOCNO" NUMBER,  "DOCDT" DATE,  "DOCTYP" VARCHAR2(2),  "REFCD" VARCHAR2(6),  "NETVALLC" NUMBER(17,3),  "NETVALFC" NUMBER(17,3),  "FILE_NAME" VARCHAR2(250),  "MIME_TYPE" VARCHAR2(250),  "DOCIMG" BLOB,  "CRTDT" DATE,  "CRTUSER" VARCHAR2(6)    ) / 2) Import Plugin  region_type_plugin_de_danielh_apexsignature.sql 3) Import Static file  apexsignature.js , apexsignature.min.js, signature_pad.js, signature_pad.min.js 4)  Copy the staic file path to  UserInterface -- Java Script  #APP_IMAGES#apexsignature.js #APP_IMAGES#apexsignature.min.js #APP_IMAGES#s...

Note 1:- Pre-rendering only advisable if you want to generate excel from Interactive Grid Page other wise below process you can directly call from submit Page --> process  Note 2:-  If calling from submit Page (button) --> then make sure Reload on Submit should be "Always" on page property  1) Create Blank Page --> Pre-Rendering --> Before Header --> Process --> Download Excel  declare     l_highlights     apex_data_export.t_highlights;     l_context        apex_exec.t_context;     l_export         apex_data_export.t_export;     l_print_config    apex_data_export.t_print_config; begin     -- apex_data_export.add_highlight(     --     p_highlights          => l_highlights,     --     p_id                  => ...

1)  BEGIN  apex_mail.send(p_to   => 'abc@gmail.com'/*l_to_addr*/,                                    p_from => 'def@gmail.com'/*l_from_addr*/,                  p_subj => 'Test33344',                  p_body => 'Service Request Note:- This is a system generated Email. Please DO NOT REPLY to it.'); APEX_MAIL.PUSH_QUEUE; END; Lets assume you are getting ORA-27492 Unable to run job "APEX_200200" ORACLE_APEX_MAIL_QUEUE scheduler unavailable error then perform following two line code 1) Login as sys/ dba without container  2)  alter system set job_queue_processes = 100; 3) connect now sys/<>@container as sysdba 4) Perfrom  begin APEX_MAIL.PUSH_QUEUE; end;