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.........................