Chunked Multiple File Upload with AJAX in Oracle APEX

How To Use ORDS RESTful Services In Oracle Apex

;

The Oracle Application Express workshop automatically has an example of RESTful Service Module, oracle.example.hr. You can enter sample service while registering the schema via ORDS.

Steps To How To Use ORDS RESTful Services In Oracle Apex

1. Create a Table;

CREATE TABLE "SLIDESHOW_IMG"
(
    "OID"                 NUMBER,
    "IMAGE"               BLOB,
    "MIME_TYPE"           VARCHAR2 (100),
    "FILE_NAME"           VARCHAR2 (100),
    "LAST_UPDATE_DATE"    DATE,
    "SET_COLUMN"          VARCHAR2 (100),
    "IMAGE_NO"            NUMBER,
    "SLIDER_TEXT"         VARCHAR2 (100),
    "SLIDER_LINK"         VARCHAR2 (100),
    CONSTRAINT "PK_SLIDESHOW_IMG" PRIMARY KEY ("OID") USING INDEX ENABLE
)

Create A Trigger;

CREATE OR REPLACE EDITIONABLE TRIGGER "SLIDESHOW_IMG"
    BEFORE INSERT
    ON "SLIDESHOW_IMG"
    FOR EACH ROW
BEGIN
    IF :NEW."OID" IS NULL
    THEN
        SELECT "SLIDESHOW_IMG_SEQ".NEXTVAL INTO :NEW."OID" FROM sys.DUAL;
    END IF;
END;
/

ALTER TRIGGER "SLIDESHOW_IMG"
    ENABLE
/

2. Create A Form Page And Insert Some Data.;

3. Go To Sql Workshop >> Click- Restful Services;

4. Click- Modules- Click- Create New Modules;Module Name-Slideshow Image,
Base Path- /get/,
Click – Create Modules

5. Create Templates-;URI Template – view/{id},
Click – Create Templates

6. Create Handlers-;Source Type – Media Resource, Source Code-

SELECT MIME_TYPE, IMAGE
  FROM SLIDESHOW_IMG
 WHERE oid = :id

7. Copy Full URL And Check If It Is Working Properly.;

 

🔗 Demo Application-
            URL- Demo Application
            Username - demo, Pass- demo
 

I hope everyone will like it. Please watch the full video,
Comment on any of your problems, I will try my best to solve the problem, In-Shah Allah. Everyone's cooperation is desirable. Visit my blog site, new technology related videos, you will get different types of tutorials of Oracle Apex, and hopefully, you can use them in your daily work.
Please stay tuned by subscribing to the YouTube channel, and encourages new videos to be uploaded.
=================
Visit my site to get more collaborative posts about Oracle Apex and subscribe to my YouTube channel. Thanks.
Comment on any of your issues, I will try my best to solve the problem, In-Shah Allah. Everyone's cooperation is desirable.
Visit my blog site, new technology-related videos, you will get different types of tutorials of Oracle Apex, and hopefully, you can use them in your daily work.
==============================

🙍🏾‍ Md jABER HOSSEN
📲 Mobile- +8801760688286
📨 Email- jaberit786@gmail.com
🌐 FB- facebook.com/mdjaber.hossen1
Please Subscribe to My Channel

Many thanks for visiting the site.

Then Enjoy.........................