Skip to content

The variable l_proc_name declared as VARCHAR2(100) does not have a valid size since Oracle12.2 #259

Description

@akinet

The procedures log_internal, log_error, and time_start have the variable l_proc_name declared as VARCHAR2(100). These variables store owner+package_name+procedure_name. Starting with Oracle 12.2, these names can be up to 128 bytes long. Therefore, 100 bytes is insufficient to store this information. l_proc_name must be declared as VARCHAR2(384) to store this information.

In the time_start procedure, it is not necessary to modify this declaration, as this variable is never used within the procedure.

Activity

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

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions