Issues

• DBMS_OUTPUT: Comparison with orafce and SET SERVEROUTPUT implementation

  rophy/IvorySQL#31 · Filter by author rophy opened on Jan 8, 2026

• Oracle DBMS_OUTPUT: Multiple ENABLE() Calls Behavior

  bug
  rophy/IvorySQL#30 · Filter by author rophy opened on Dec 25, 2025

• Oracle DBMS_OUTPUT Memory Allocation Analysis

  bug
  rophy/IvorySQL#29 · Filter by author rophy opened on Dec 25, 2025
  2

• PL/SQL to PL/iSQL Migration Guide: Transaction Control in Exception Blocks

  rophy/IvorySQL#28 · Filter by author rophy opened on Dec 8, 2025

• PRAGMA AUTONOMOUS_TRANSACTION fails in standalone procedures but works in packages

  rophy/IvorySQL#27 · Filter by author rophy opened on Dec 8, 2025
  1

• DBMS_OUTPUT: Re-ENABLE should preserve buffer content like Oracle

  rophy/IvorySQL#26 · Filter by author rophy opened on Dec 3, 2025

• ROWNUM: LATERAL subquery doesn't reset counter for each outer row (differs from Oracle)

  rophy/IvorySQL#24 · Filter by author rophy opened on Dec 3, 2025

• ROWNUM: INTERSECT/EXCEPT shares counter across both sides (differs from Oracle)

  rophy/IvorySQL#23 · Filter by author rophy opened on Dec 3, 2025

• DBMS_OUTPUT: Buffer size below 2000 should be silently adjusted, not rejected

  rophy/IvorySQL#22 · Filter by author rophy opened on Dec 1, 2025

• Bug: ROWNUM counter not reset in correlated subqueries

  bug
  rophy/IvorySQL#14 · Filter by author rophy opened on Nov 29, 2025

• Bug: ROWNUM in SELECT list of subquery returns 0 instead of actual values

  rophy/IvorySQL#13 · Filter by author rophy opened on Nov 29, 2025
  2

• ROWNUM→LIMIT optimization breaks Oracle compatibility with aggregation/ORDER BY/DISTINCT/GROUP BY

  bug
  rophy/IvorySQL#12 · Filter by author rophy opened on Nov 29, 2025

• Oracle Compatibility Gap Analysis

  rophy/IvorySQL#4 · Filter by author rophy opened on Nov 25, 2025
  1

• Support for PRAGMA AUTONOMOUS_TRANSACTION

  rophy/IvorySQL#2 · Filter by author rophy opened on Nov 24, 2025

• For loop syntax is not supported

  bug
  rophy/IvorySQL#1 · Filter by author rophy opened on Nov 17, 2025