Oracle APEX : How to Use Signature Plugin

My blog
apex4help.blog...
My Full course on Udemy
www.udemy.com/...
----
Resource
apex.world/ord...

[@mrmadan84]

تسلم يا بشمهندس على

[@wizzeico4589]

الله عليك ي هندسه متحفنا دوما

[@alisaleh84]

تسلم يا غالى

[@maheralnakeb4158]

جزاكم الله خيرا

[@kas6245]

Hi Sir,Need your help,How to Link document Scanners With apex

[@thegogo145]

hello i have a question does this plugin work with apex 22.1.0?

[@alisaleh84]

Check plug-in page in github

[@hashimhussain9164]

i having trouble in inserting signature in (apex_collections) table...can you please help me?

[@alisaleh84]

www.udemy.com/course/full-track-be-oracle-apex-developer/?couponCode=APEX_5

[@hashimhussain9164]

Dear i am using same code and i have watched your video completely but data is not inserting....even its own apex table

[@alisaleh84]

@@hashimhussain9164 check your table design

[@alisaleh84]

@@hashimhussain9164 CREATE TABLE "SIGNATURE" ( "SIGNATURE_ID" NUMBER NOT NULL ENABLE, "SIGNATURE_NAME" VARCHAR2(200), "SIGNATURE_TYPE" VARCHAR2(200), "SIGNATURE_DATE" DATE, "SIGNATURE_FILE" BLOB, CONSTRAINT "SIGNATURE_PK" PRIMARY KEY ("SIGNATURE_ID") ENABLE ) / CREATE OR REPLACE TRIGGER "BI_SIGNATURE" before insert on "SIGNATURE" for each row begin if :NEW."SIGNATURE_ID" is null then select "SIGNATURE_SEQ".nextval into :NEW."SIGNATURE_ID" from sys.dual; end if; end; / ALTER TRIGGER "BI_SIGNATURE" ENABLE /

[@hashimhussain9164]

Basically api is not working 1st api insert its own table which is (apex collection)then Db table....so the issue is when i click save button data is not insert in its own api table(apex_collection)

[@luizschweinitz2060]

Hello! ali saleh ali... Congratulations!!! I have a question. How to solve the problem: ORA-06502: PL/SQL: numeric or value error: character to number conversion error.. Thank you

[@alisaleh84]

Hi sir Did you face this error with this plugin

[@luizschweinitz2060]

@@alisaleh84 yes, when i change the type for display image or download.

[@alisaleh84]

www.javainhand.com/2020/04/display-images-into-reports-in-oracle-apex.html

[@luizschweinitz2060]

@@alisaleh84 Thank you so much. Your course at udemy is lifetime access?

[@alisaleh84]

@@luizschweinitz2060 NO , it will be avalible all time get it here from with 150 $ instead of 200 $ www.udemy.com/course/full-track-be-oracle-apex-developer/?couponCode=APEX_4_22

[@hashimhussain9164]

أواجه مشكلة في إدراج التوقيع في جدول (apex_collections) ... هل يمكنك مساعدتي؟

[@alisaleh84]

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 -- using collection 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 -- using Tables insert into SIGNATURE (SIGNATURE_FILE, SIGNATURE_NAME,SIGNATURE_TYPE,SIGNATURE_DATE) values (l_blob,l_filename,l_mime_type,SYSDATE) ; END IF; -- END;

[@hashimhussain9164]

I followed your video but its not inserting even its own table

[@hashimhussain9164]

thanks alot