Iudith Mentzel noticed a problem in my OS_LIST_UNIQUE function. It relied on the Ordering System (OS) number being incremental. For example [3,2,1] would not be considered a unique list. The problem lay in the following steps: Load the passed JSON Array into a table 1 Loop through table 1 sequentially to load unique values into … Read more
April 1, 2018 Oracle Spokesperson April Fulz released the following brief statement today: The Oracle database has undergone many changes to it’s release numbering scheme over the years that caused an undue amount of confusion. To alleviate the confusion we have decided to go right back to the beginning with Release 1.0. You may know … Read more
This post further explains how JSON queries and indexes interact with the Oracle optimizer. The code shown below relies on the indexes created in the previous post here. Here’s a quick summary of the indexes: JSON_4 JSON_VALUE(“JSON_COL” FORMAT JSON , ‘$.col’ RETURNING VARCHAR2(4)… JSON_5 JSON_VALUE(“JSON_COL” FORMAT JSON , ‘$.col’ RETURNING VARCHAR2(5).. JSON_6 JSON_VALUE(“JSON_COL” FORMAT JSON … Read more
Arrgh! I just spent several days working through a bug in a large (1000+ line) unfamiliar package that was raising unexpected NO DATA FOUND errors. After working through several calls to the procedure and monitoring the results I isolated the problem to code very similar to the following. CREATE OR REPLACE PROCEDURE abc AS v_a … Read more
There is no excerpt because this is a protected post.
My blog…and backup…got corrupted.