Dear i am using same code and i have watched your video completely but data is not inserting....even its own apex table
@alisaleh844 жыл бұрын
@@hashimhussain9164 check your table design
@alisaleh844 жыл бұрын
@@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 /
@hashimhussain91644 жыл бұрын
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)
@luizschweinitz20602 жыл бұрын
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
@alisaleh842 жыл бұрын
Hi sir Did you face this error with this plugin
@luizschweinitz20602 жыл бұрын
@@alisaleh84 yes, when i change the type for display image or download.
@@alisaleh84 Thank you so much. Your course at udemy is lifetime access?
@alisaleh842 жыл бұрын
@@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
@hashimhussain91644 жыл бұрын
أواجه مشكلة في إدراج التوقيع في جدول (apex_collections) ... هل يمكنك مساعدتي؟
@alisaleh844 жыл бұрын
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;
@hashimhussain91644 жыл бұрын
I followed your video but its not inserting even its own table