[Fix]-ORA-00911 invalid character-newline

Wikitechy | 1933 Views | oracle | 28 May 2016

 

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





Workshop

Bug Bounty
IOT Hackathon
Webinar

Join our Community

Advertise