Oracle
-
MLE type mapping: passing JSON to JavaScript functions in Oracle Database 26ai
Everyone knows that JSON is very popular, and that includes its use in databases. Turns out…
-
Dealing securely with state changes in Multilingual Engine for Oracle AI Database 26ai
Most PL/SQL developers are aware of the ORA-04068: existing state of packages has been discarded error…
-
Using the Operating System’s certificate store instead of an Oracle wallet in Oracle AI Database 26ai
Before jumping into the example, it’s worth highlighting an important aspect: security. Therefore you cannot simply…
-
Linting MLE JavaScript Modules in Continuous Integration Pipelines
Continuous Integration (CI) is the process of automatically building and testing your application’s code each time…
-
Data Access using Java Stored Procedures in Oracle Database
Recently I had to troubleshoot a problem related to Java stored procedures in Oracle Database. SQL…
-
Avoiding pitfalls when using cURL in CI/CD pipelines
Continuous Integration/Continuous Delivery (or Deployment, depending on your point of view) pipelines are at the core…
-
Creating a Java Stored Procedure in Oracle Database
This blog post provides a quick (and dirty) way of creating Java Stored Procedures in Oracle…
-
Generating Table DDL in Oracle Database
Generating table DDL is a common requirement. Unfortunately it’s not quite common enough for me to…
-
DOAG 2021 gems: DBMS_XPLAN.COMPARE_PLANS
The most excellent #DOAG2021 conference ended last week. I have attended quite a few presentations and…
