CODEWITHSUNDEEP
oracle-databaseplsql
jcgarciam
jcgarciam

Reputation: 392

PL/SQL Schema name same as Oracle Keyword

I know this sounds bizarre, but I need to execute some PL/SQL where the owner of the package has a clash with an Oracle reserve word, IF.

Essentially, the owner of the object is IF. When I use SQL Developer to execute the procedure, the generated script throws me errors since its trying to declare a cursor variable as:

 variable_name IF.MYCUSTOM_TYPE

Currently I have no control over the schema, so I can't change anything.

Upvotes: 1

Views: 377

Answers (1)

user1339920
user1339920

Reputation:

Use double quotes around the schema name, like 

"IF".MYCUSTOM_TYPE

Upvotes: 8

Related Questions