Database Administration (MOSC)

MOSC Banner

11g ORA-00911 and ASCII Character 255

edited Apr 18, 2011 1:37AM in Database Administration (MOSC) 2 commentsAnswered
 I have a somewhat simple SQL statement that has been running well for years in 8i and 10g. I ran it in 11g2 and had an ORA-00911 - invalid character - error returned. I copied the statement from TOAD to MS Word and noticed some little circles instead of spaces. These little circles are ASCII 255 characters instead of ASCII 32 spaces. After replacing the ASCII 255 characters with ASCII 32's, it runs properly in 10g and 11g.

It seemed to run correctly in SQL Plus but that might just be due to cleanup when copying and pasting. I noticed that when I copied the statement from Word back to TOAD, the ASCII 255's were replaced by 32s.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center