CODEWITHSUNDEEP
plsql
Ram
Ram

Reputation: 1054

Getting the rowtype of a table named after an Oracle PL/SQL keyword

I have a table named CASE.

And let's say I have the ff code:

declare
  a CASE%rowtype;
begin
  null;
end;

The above code will throw the error: PLS-00103: Encountered the symbol "CASE" when expecting one of the following: ...

Is there anyway for me to create a variable of CASE%rowtype without manually creating the datatype itself? Thanks!

Upvotes: 0

Views: 124

Answers (1)

Raphaël Althaus
Raphaël Althaus

Reputation: 60493

as Case is a reserved keyword,

you can escape it with double quotes

a "CASE"%rowtype;

useless to say that you should avoid reserved keywords in object naming... (or not that useless ?)

Upvotes: 2

Related Questions