Solved

)RA-0091 Error, please help

Posted on 2011-03-11
3
420 Views
Last Modified: 2012-05-11
Hi Experts,

invalid character

Cause: identifiers may not start with any ASCII character other than letters and numbers. $#_ are also allowed after the first character. Identifiers enclosed by doublequotes may contain any character other than a doublequote. Alternative quotes (q'#...#') cannot use spaces, tabs, or carriage returns as delimiters. For all other contexts, consult the SQL Language Reference Manual.

Action: None

Please help me to solve this error.

Thanks & Regards
Dileep.
0
Comment
Question by:dileepav
3 Comments
 
LVL 75

Accepted Solution

by:
käµfm³d   👽 earned 250 total points
ID: 35108636
The error message is pretty self-explanatory--you have an invalid identifier in your query. Without seeing the actual query, we cannot tell you which one it is  : )
0
 
LVL 14

Assisted Solution

by:ajexpert
ajexpert earned 250 total points
ID: 35118777
Are you trying to create an object or execute query?  You should post the your query (mask it if needed) so that we can understand the problem and provide proper solution.

Have a look at this if hels
http://www.techonthenet.com/oracle/errors/ora00911.php


HTH


0
 

Author Closing Comment

by:dileepav
ID: 35242817
Thx Experts
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
constraint check 2 40
Query still returning duplicates 5 27
How to update the value of duplicated records (except latest one) 2 18
Sql server function help 15 28
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question