Hello, We have a Java process that calls OR stored procedure via JPA. This procedure was initially declared outside of a package, and everything worked fine, but when we moved it into a package, we encountered date conversion problems related to the incorrectly initialized Oracle...

Hi all, I have a hierarchy between levels in my_hierarchy table (between id_lvl and id_lvl_sup). Each level (lvl) may have items (id_item), and each item has a category (id_item_sup). These data is stored in my_items table. Now I want to build a report based on the my_view view. ...

My goal is to create a fast refreshable materialized view (MV) that holds all the combinations of records in specific related tables. So also the 'incomplete combinations'. So the query that is needed contains a full outer join. First a disclaimer about using LiveSQL. I tried but...

I’m using a Polymorphic Table Function (PTF) and adding a new column TIMESTAMP_CALCULATED of type TIMESTAMP with fractional seconds scale 9. In FETCH_ROWS I populate it with a constant value: 2026-01-01 01:01:01.123456789 However, when selecting the PTF output, the value appears ...

Hi Tom, I got a Web Form that is able to display data to users and read user input back into the database. It is very important to be able to read user input back into the database. This is why I did not use out-of-the-box solutions like "owa_utils.read SQL into table". However, ...