Signature in Oracle APEX Page

-
 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#signature_pad.js
#APP_IMAGES#signature_pad.min.js

5) Go to any Page --> Create Region Signature--> Type APEX-Signature [Plug-in]

6) Go to Attribute of Signature --> PL/SQL Code
DECLARE
  --
  l_collection_name VARCHAR2(100);
  l_clob            CLOB;
  l_blob            BLOB;
  l_filename        VARCHAR2(100);
  l_mime_type       VARCHAR2(100);
  l_token           VARCHAR2(32000);
  --
BEGIN
  -- get defaults
  l_filename  := 'signature_' ||
                 to_char(SYSDATE,
                         'YYYYMMDDHH24MISS') || '.png';
  l_mime_type := 'image/png';
  -- build CLOB from f01 30k Array
  dbms_lob.createtemporary(l_clob,
                           FALSE,
                           dbms_lob.session);
  FOR i IN 1 .. apex_application.g_f01.count LOOP
    l_token := wwv_flow.g_f01(i);
  
    IF length(l_token) > 0 THEN
      dbms_lob.writeappend(l_clob,
                           length(l_token),
                           l_token);
    END IF;
  END LOOP;
  --
  -- convert base64 CLOB to BLOB (mimetype: image/png)
  l_blob := apex_web_service.clobbase642blob(p_clob => l_clob);
  --
  -- create own collection (here starts custom part (for example a Insert statement))
  -- collection name
  l_collection_name := 'APEX_SIGNATURE';
  -- check if exist
  IF NOT
      apex_collection.collection_exists(p_collection_name => l_collection_name) THEN
    apex_collection.create_collection(l_collection_name);
  END IF;
  -- add collection member (only if BLOB not null)
  IF dbms_lob.getlength(lob_loc => l_blob) IS NOT NULL THEN
    apex_collection.add_member(p_collection_name => l_collection_name,
                               p_c001            => l_filename, -- filename
                               p_c002            => l_mime_type, -- mime_type
                               p_d001            => SYSDATE, -- date created
                               p_blob001         => l_blob); -- BLOB img content

     insert into signature (compcd,locncd,brcd,deptcd,docno,docdt,doctyp,refcd,netvallc,netvalfc,file_name,mime_type,docimg,crtdt,crtuser)
    values (:p710_compcd,:p710_locncd,:P710_ICSLOC,:P710_CUSTADDR4,:p710_docno,:p710_docdt,:p710_doctyp,:p710_custcd,:P710_NBT_SNETVAL,:P710_NBT_SNETVALLC,l_filename,l_mime_type,l_blob,sysdate,
    :APP_USERCD);                         
  END IF;
  --
END;

7)  Create Two Button on Signature Region --> Save (Static ID #Signature_Save), Clear (Static ID #Signature_Clear)

8)  Go to Attribute property of Signature Region --> 

 --> Define value for Clear Button JQuery Selector  to #Signature_Clear
--> Define value for Save Button JQuery Selector  to #Save_Signature

9) Create Another Region (Signature Report) with Classic /Interactive Report 
SQL Query :
select crtdt,crtuser,
decode(nvl(dbms_lob.getlength(docimg),0),0,null,
'<img class="center" alt="'||apex_escape.html_attribute(docno)||'" title="'||apex_escape.html_attribute(docno)
||'" style="border: 4px solid #CCC; -moz-border-radius: 4px; -webkit-border-radius: 4px;" '
||'src="'||apex_util.get_blob_file_src('P4302_DOCIMG',docno)||'" height="100" width="350" />') DOCIMG
from signature where docno=:p710_docno 

10) Create DA on Save button --> Refresh Page --> Signature Report

11) Create DA on Clear Button --> Behaviour--> Defined by DA Action 



Signature Region 



Signature Report 







       


Comments

Post a Comment

Popular posts from this blog

Telegram Integration with Oracle

-
 How to Integrate Telegram with Oracle Apex 1) create Telegram Account in your Mobile like whatsapp 2) Ones you register in telegram apps serach for BotFather 3) To Create New Bot u need to enter below command  /newbot  Alright, a new bot. How are we going to call it? Please choose a name for your bot. Macsbot Good. Now let's choose a username for your bot. It must end in `bot`. Like this, for example: TetrisBot or tetris_bot. MacsOmanBot Done! Congratulations on your new bot. You will find it at t.me/MacsOmanBot. You can now add a description, about section and profile picture for your bot, see /help for a list of commands. By the way, when you've finished creating your cool bot, ping our Bot Support if you want a better username for it. Just make sure the bot is fully operational before you do this. Use this token to access the HTTP API:<Here you will prompt with your api> 4) /mybots (this command will return the list of bots which you have created) ...
Read more

The username or password for the connection pool named |apex||, are invalid, expired, or the account is locked

-
  1. Execute the following command from SQL Plus as the SYS user:  Conn sys/Pass@xe as sysdba  (connect as container if 12c then  ALTER SESSION SET container = CDB$ROOT;) Alter user ords_public_user identified by xxxx; ALTER USER ORDS_PUBLIC_USER ACCOUNT UNLOCK; Connect as PDB Conn sys/Pass@xepdb1 as sysdba (if 12c  ALTER SESSION SET container = PDB1;) Alter user APEX_PUBLIC_USER identified by xxxx; Alter user APEX_REST_PUBLIC_USER identified by xxxx; Alter user APEX_LISTENER identified by xxxx; 2. Unlock the users: ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK; ALTER USER APEX_REST_PUBLIC_USER ACCOUNT UNLOCK; ALTER USER APEX_LISTENER ACCOUNT UNLOCK; ALTER USER ORDS_PUBLIC_USER ACCOUNT UNLOCK; 3. Now create a profile for the APEX related users: Create profile apex_public_profile limit password_life_time unlimited; 4. Assign the profile to the APEX users: alter user apex_public_user profile apex_public_profile; alter user apex_rest_public_user profile apex_public_pr...
Read more

Enabled SQL Developer Web (SDW) & ORDS Database API ORDS 19.4

-
SQL Developer Web (SDW)  ORDS 19.2 to 19.4 Migration /  Basic Setup to Enable ORDS Database API Bsic Information  Installing Oracle REST Data Services https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/19.4/aelig/installing-REST-data-services.html#GUID-673D35DD-9811-42F8-A500-4F494F79C470 https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/19.4/aelig/installing-REST-data-services.html#GUID-2C42D982-BF08-48E3-A4C6-3FE1A78287E3 Using Oracle® SQL Developer Web https://docs.oracle.com/en/database/oracle/sql-developer-web/19.2.1/sdweb/about-sdw.html#GUID-AF7601F9-7713-4ECC-8EC9-FB0296002C69 How to Configure / Run ORDS for SQL Developer Web and APEX in Standalone Mode: ORDS 19.4 + (Doc ID 2628004.1) GOAL This document is an overview on how to configure and run ORDS standalone for SQL Developer Web using the command line interface. It also includes the steps related to setting up APEX, since the ability to run APEX as well as SQL Develo...
Read more