[Fix]-ORA-00911 invalid character-newline
ORA-00911: invalid character \n
Scenario:
Below is my query:
select distinct FirstName from wikiTechyUsers
where upper(LastName) like upper(:lna)
AND UserRights(FirstName, :userId) = 'Admin' order by FirstName
Error:
The above when executed code returns the error as:
ORA-00911: invalid character \n
Reason:
Usage of editors cause this type of error.
Fix:
This is an error occurring due to copy paste from editors. Highlighted below is a character different from normal round brackets, and that is causing the error:
select distinct FirstName from wikiTechyUsers
where upper(LastName) like upper(:lna)
AND UserRights(FirstName, :userId) = 'Admin' order by FirstName