About Oracle and Oracle ā'pěks (#orclapex)

  Creating Applications for Mobile Devices & PWA in Oracle APEX Objective The objective of this blog post is to give you some tips and tricks about creating an applications for mobile devices and power of Progressive Web Application (PWA) in Oracle APEX . National Webinar Series 2022 - AUSOUG It was last week that, I presented this topic at the National Webinar Series 2022 , organized by the Australian Oracle User Group ( AUSOUG ). I look forward to seeing you all at AUSOUG National Webinar Series 2022 (25th May 2022, 7.30 AM IST). Get tickets now for this virtual event for FREE at https://t.co/r61CraPmNq #oracle #orclAPEX #orclAPEXIndia #orclAPEXAPAC #orclAPEXJPAC #inoaug @oracleace @AUSOUG @orclapexworld pic.twitter.com/W0ksu5gjgX — Karkuvelraja Thangamariappan (@tkarkuvelraja) May 24, 2022 I would like to thank the Australian Oracle User Community for providing me with such a wonderful opportunity to speak about Oracle APEX in the world community. What I was presente

      Razorpay Integration with Oracle APEX The objective of this blog post is to show you how to list all Razorpay Payments (Specific to particular account) in Oracle APEX using  APEX_WEB_SERVICE  API. Before we get into the topic, let's take a look at the following link, which will help you to understand how Razorpay payment gateway can be done in Oracle APEX. 1)  Razorpay Payment Gateway Integration with Oracle APEX 2)  Invoking a RESTful Style Web Service List all Razorpay Payments Below are steps involved to get this process done. 1) Get Razorpay API Keys 2) Get Razorpay Fetch Multiple Payments API End Point 3) Invoke  Razorpay Fetch  Multiple  Payments API  with Postman 4) Create a Sample Application 5) List all  Razorpay Payments  in the form of Report using APEX_WEB_SERVICE API I) Get Razorpay API Keys API key is a combination of the  key_id  and  key_secret  and is required to make any API request to  Razorpay . You also have to implement the API key in your code as part o

    Razorpay Integration with Oracle APEX The objective of this blog post is to show you how to list all Razorpay Orders (Specific to particular account) in Oracle APEX using  APEX_WEB_SERVICE  API. Before we get into the topic, let's take a look at the following link, which will help you to understand how Razorpay payment gateway can be done in Oracle APEX. 1) Razorpay Payment Gateway Integration with Oracle APEX 2)  Invoking a RESTful Style Web Service List all Razorpay Orders Below are steps involved to get this process done. 1) Get Razorpay API Keys 2) Get Razorpay Fetch Orders API End Point 3) Invoke  Razorpay Fetch Orders API  with Postman 4) Create a Sample Application 5) List all  Razorpay Orders  in the form of Report using APEX_WEB_SERVICE API I) Get Razorpay API Keys API key is a combination of the  key_id  and  key_secret  and is required to make any API request to  Razorpay . You also have to implement the API key in your code as part of your integration process. Step

     Create REST Data Services in Oracle APEX Using the Oracle REST Data Services PL/SQL API The objective of this blog post is to show you how to create REST Data Services in Oracle APEX using a PL/SQL API (Oracle REST Data Services: ORDS) . Oracle APEX provides a sample REST Data Services that can be accessed from Sample APEX Application and it can be installed from Gallery. RESTful Data Services can be created with Oracle APEX. The same can be done using Oracle REST Data Services PL/SQL API . To navigate to RESTful Data Services, SQL Workshop --> RESTful Services . This sample REST Data Service (Screenshot) has module , templates , handlers and parameters . Module oracle.example.emp Templates 1) empinfo/  2) employees/:id Handlers  1) The empinfo/ template has a GET handler 2) The employeees/:id has GET and PUT handler Parameters: The employees/:id template has a PUT handler and it has two parameters It's already been developed by Oracle APEX and now we will build it

     The objective of this blog post is to show you how to integrate Razorpay Payment Gateway with Oracle APEX. What is Razorpay? Razorpay is the only converged payments solution company in India that allows your business to accept, process, and disburse payments via its product suite . With Razorpay, you have access to all payment modes, including credit and debit cards, UPI, and popular mobile wallets. Razorpay Payment Gateway Integration with Oracle APEX 20.x Below are the steps involved to get this process done. 1) Create a Razorpay Account 2) Get Razorpay API Keys in Test Mode 3) Get and Invoke Razorpay Orders API with Postman 4) Create a required Database Objects 5) Create a Sample Oracle APEX Application 6) Invoke Razorpay Payment Gateway using APEX_WEB_SERVICE API (Payment Process) 7) Verify Payment Status 8) Setup REST End Point to Receive Razorpay Webhook Response 9) Setup Razorpay Webhook 10) Test Card I) Create a  Razorpay  Account II) Get Razorpay API Keys in Test Mode AP