Skip to content
This repository was archived by the owner on Feb 2, 2026. It is now read-only.
This repository was archived by the owner on Feb 2, 2026. It is now read-only.

Parse error using self instead of table name in %type declaration #33

Closed
Closed
Parse error using self instead of table name in %type declaration#33
Assignees
PhilippSalvisberg
Labels
bugSomething isn't working
Milestone
v5.0.1

Description

@PhilippSalvisberg
PhilippSalvisberg
opened on Mar 26, 2024

In the body of an object type you can have code similar to the following:

declare
   l_sum self.column_name%type;
begin
   null;
end;
/

self causes a parse error since it is a keyword. The workaround is to use "SELF".

Activity

  1. PhilippSalvisberg
    added
    bugSomething isn't working
    on Mar 26, 2024
  2. PhilippSalvisberg
    added this to the v5.0.1 milestone on Mar 26, 2024
  3. PhilippSalvisberg
    self-assigned this
    on Mar 26, 2024

  4. PhilippSalvisberg commented on Mar 26, 2024

    @PhilippSalvisberg
    PhilippSalvisberg
    on Mar 26, 2024
    CollaboratorAuthor

    fixed via Azure DevOps commit 7f15c268c130830aae38cc6d88c255db4cd8932c

  5. PhilippSalvisberg
    closed this as completedon Mar 26, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions