1.0

1.0.0

• Initial release of O2 Extensions

  • O2Types

  • O2Functions

  • O2Views

  • DBMS_ALERT

  • DBMS_OUTPUT

  • DBMS_PIPE

  • DBMS_SQL

---

1.0.1

Others

• Improved O2 Common Module functionality: Fixed errors in DBMS_ALERT, DBMS_PIPE, DBMS_OUTPUT, O2Views and some other functions (apply error fixes in bulk for functions with multiple out parameters)

---

1.0.2

Troubleshooting

• Resolved "Failed to open version file" error when viewing O2_EXTENSION_VERSION_INFO view.

Others

• O2Views: Minor bugfix in create extension initialization function

• O2Types: Minor bugfix in create extension initialization function

---

1.0.3

Troubleshooting

• Resolved an issue with MONTHS_BETWEEN input argument date values ignoring and incorrectly calculating the presence of hours/minutes/seconds.

• Resolved server crashes when using the ROUND function.

• Resolved the session goes down when running the MEDIAN aggregation function, if any of the records to be aggregated contain NULL records.

Feature improvements

• Improved function functionality to handle timestamp type variables as first argument of TO_DATE

  function

• When TO_TIMESTAMP_TZ function arguments are NULL or ''(empty string), like oracle

  Improved to return null values

Others

• DBMS_OUTPUT, DBMS_ALERT : resolved errors related to internal transactions for PG14, PG15

  versions

Caution

O2Functions Extension needs to be regenerated.

---

1.0.4

Troubleshooting

• Modify DBMS_SQL.BIND ARRAY index parameter range calculation method to align with Oracle

• Additionally, an error is thrown if a value outside the array range is specified or if it is put into an empty array.

• Resolved the DBMS_PIPE.NEXT_ITEM_TYPE Result Value Error

Others

• Improved performance of MEDIAN function and session down when performing function on columns with only NULLs

Caution

DBMS_PIPE extension needs to be regenerated.

---

1.0.5

Troubleshooting

• Resolved session crashes when using UTL_FILE

Others

• Resolved an issue where callstack information from Assert, SIGSEGV, etc. was not properly captured in the log.

Caution

O2Functions and DBMS_OUTPUT extension need to be regenerated.

---

1.0.6

Troubleshooting

• Improved an issue where calling the new_line(file) interface of the new_line function in the UTL_FILE package without a second argument value would cause the second argument value to have a garbage value and write an unintended number of newlines.

Others

• Developed feature to detect 'attempting to wait on uncommitted signal from same session' in DBMS_ALERT

Caution

UTL_FILE extension needs to be regenerated.

---

1.0.7

Troubleshooting

• Resolved an issue where the linesize argument of the fopen function of the UTL_FILE package was omitted, resulting in an unintended error with a memory garbage value when called.

Others

• UTL_FILE package: Improved internal logic across the board for all functions to ensure that when an argument is omitted, the argument does not have a memory garbage value and cause unintended action.

---

1.0.8

Troubleshooting

• Resolved an issue that oracle.sysdate result was not inserted into the corresponding type column due to incompatibility with the timestamp type caused by changing in the definition of oracle.date type during the uprade from v.1.0.5 to 1.0.6 patch.

Caution

O2Types extension needs to be regenerated.

---

1.0.9

Troubleshooting

• Resolved an issue that caused the server to crash when the second argument (format) of a TRUNC

  function that takes a date type as an argument was omitted.

Caution

O2Functions extension needs to be regenerated.