Enabling graphQL on ORDS
In today’s data-driven world, the need for flexible and efficient data querying solutions has never been greater. Traditional REST APIs have served us well, but they often fall short in scenarios requiring more granular data fetching. With GraphQL, a powerful query language for APIs that allows clients to request exactly the data they need. Combining
Simplified QR Code Generation with JavaScript’s MLE
In this blog post, we’ll explore how to utilize JavaScript/MLE to develop a QR Code application. Before delving into the application creation process, it’s important to note that although I operate in the APEX 23.2 version environment, the JavaScript/MLE functionality is available as early as version 23.1, residing within the Oracle Database 23c Free-Developer Release.
JavaScript on Oracle 23c powered by GraalVM
In Oracle 21c introduces JavaScript as a new language for server-side development, adding to its existing capabilities. JavaScript, widely known for its versatility and popularity in both front-end and back-end development, has been integrated into Oracle’s Converged Database concept. This concept emphasizes a flexible, multi-model database system that caters to various development needs, making development
Apex and Ubiquitous Database Search
Do you wonder how to apply a Google-like search (“ubiquitous search”) engine on the Oracle database? “Oracle Text” is a product within the database capable of producing a full-text (keyword) search from different documents. It is fully integrated and available in all versions of the database without any further installation. It has been around for
APEX_WEB_SERVICE Simplifies Oauth2.0 Web Services
In OAuth 2.0 client credentials, acquiring a token necessitates passing the client ID and client secret. Upon successful validation, a token is returned, which is then utilized to access other secured web services. This token remains valid for multiple calls to web services until its expiration. One method of calling web services involves using UTL_HTTP,
APEX_WEB_SERVICE Certificate Error
Encountering a certificate validation failure while utilizing the APEX_WEB_SERVICE API to call a public web service prompted this error in a newly installed local Oracle APEX environment. This issue doesn’t arise when utilizing Oracle OCI Autonomous or APEX services, as Oracle automatically generates a TLS wallet, inclusive of almost every SSL/TLS certificate. select apex_web_service.make_rest_request (p_url
