Skip to content

DBMS_OUTPUT: NULL and empty string should be stored as NULL #25

Closed

Description

@rophy

Description

Oracle treats empty strings as NULL. In DBMS_OUTPUT, both PUT_LINE('') and PUT_LINE(NULL) should store actual NULL values, which GET_LINE returns as SQL NULL.

Current Behavior

NULL values were being stored as empty strings internally.

Expected Behavior

  • PUT_LINE('') should store NULL
  • PUT_LINE(NULL) should store NULL
  • GET_LINE should return SQL NULL for these values

Verification

Verified against Oracle 23.26 Free.

Fix

Commit 1c3339a in PR #15 addresses this issue.

Activity

  1. added 3 commits that reference this issue on Dec 3, 2025
    cf94373
    8a1a877
    c9aa53f
  2. added a commit that references this issue on Dec 26, 2025
    d3f8b1f
  3. added 3 commits that reference this issue on Jan 6, 2026
    c8a793f
    db553de
    4da23a0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions