HomeHome  FAQFAQ  SearchSearch  RegisterRegister  MemberlistMemberlist  UsergroupsUsergroups  Log in  

Share | 
 

 Oracle Error Messages

Go down 
Go to page : Previous  1, 2, 3, 4, 5, 6, 7, 8, 9  Next
AuthorMessage
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Tue Mar 06, 2007 5:35 pm

Error: ORA-00903: invalid table name
Cause:
You tried to execute an SQL statement that included an invalid table name or the table name does not exist.
Action: The options to resolve this Oracle error are:
.Rewrite your SQL to include a valid table name. To be a valid table name the following criteria must be met:
.The table name must begin with a letter.
.The table name can not be longer than 30 characters.
.The table name must be made up of alphanumeric characters or the following special characters: $, _, and #.
.The table name can not be a reserved word.
Back to top Go down
View user profile
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Tue Mar 06, 2007 5:37 pm

Error: ORA-00904: invalid column name
Cause:
You tried to execute an SQL statement that included an invalid column name or the column name is missing.
Action: The options to resolve this Oracle error are:
.Rewrite your SQL to include a valid column name. To be a valid column name the following criteria must be met:
.The column name must begin with a letter.
.The column name can not be longer than 30 characters.
.The column name must be made up of alphanumeric characters or the following special characters: $, _, and #. If the column name uses any other characters, it must be enclosed in double quotation marks.
.The column name can not be a reserved word.
Back to top Go down
View user profile
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Tue Mar 06, 2007 5:38 pm

Error: ORA-00905: missing keyword
Cause:
You tried to execute a statement, but you missed a required keyword.
Action: The options to resolve this Oracle error are:
.Try fixing the statement and re-executing.
Back to top Go down
View user profile
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Tue Mar 06, 2007 5:40 pm

Error: ORA-00906: missing left parenthesis
Cause:
You tried to execute a statement, but you missed entering a required left parenthesis.
Action: The options to resolve this Oracle error are:
.Statements such as CREATE TABLE, INSERT Statements, Subqueries, and IN Function require items to be enclosed in parentheses. Try fixing the statement and re-executing.
Back to top Go down
View user profile
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Tue Mar 06, 2007 5:41 pm

Error: ORA-00907: missing right parenthesis
Cause:
You entered a left parenthesis, but missed the closing right parenthesis; or you entered invalid data within the parentheses.
Action: The options to resolve this Oracle error are:
.All parentheses must be entered in pairs. You must correct the statement and re-execute.
Back to top Go down
View user profile
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Tue Mar 06, 2007 5:43 pm

Error: ORA-00908: missing NULL keyword
Cause:
You tried to execute an SQL statement, but you missed entering the NULL keyword.
Action: The options to resolve this Oracle error are:
.This error can occur if you try to execute an SQL statement using the IS NULL or IS NOT NULL clause, but miss entering the NULL keyword.
Back to top Go down
View user profile
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Tue Mar 06, 2007 5:44 pm

Error: ORA-00909: invalid number of arguments
Cause:
You tried to call an Oracle function, but you used the incorrect number of arguments for the function.
Action: The options to resolve this Oracle error are:
.This error can be corrected by providing the correct number of arguments when calling the Oracle function.
Back to top Go down
View user profile
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Tue Mar 06, 2007 5:45 pm

Error: ORA-00910: specified length too long for its datatype
Cause:
You tried to create a VARCHAR2 or CHAR column, but you specified a length that exceeded Oracle's limits.
Action: The options to resolve this Oracle error are:
.Enter a maximum length for the VARCHAR2 or CHAR column that falls within Oracle's limits.
Back to top Go down
View user profile
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Tue Mar 06, 2007 5:46 pm

Error: ORA-00911: invalid character
Cause:
You tried to tried to execute an SQL statement that included a special character.
Action: The options to resolve this Oracle error are:
.This error occurs when you try to use a special character in an SQL statement. If a special character other than $, _, and # is used in the name of a column or table, the name must be enclosed in double quotations.
.This error may occur if you've pasted your SQL into your editor from another program. Sometimes there are non-printable characters that may be present. In this case, you should try retyping your SQL statement and then re-execute it.
.This error occurs when a special character is used in a WHERE clause and the value is not enclosed in single quotations.
Back to top Go down
View user profile
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Tue Mar 06, 2007 5:50 pm

Error: ORA-00913: too many values
Cause:
You tried to execute an SQL statement that required two sets of equal values, but you entered more items in the second set than was in the first set.
Action: The options to resolve this Oracle error are:
.This error often occurs when you are performing an INSERT statement and enter more values in the VALUES clause than the number of columns that you listed.
Back to top Go down
View user profile
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Tue Mar 06, 2007 5:51 pm

Error: ORA-00917: missing comma
Cause:
You tried to execute a statement, but you missed a required comma.
Action: The options to resolve this Oracle error are:
.Try fixing the statement and re-executing.
Back to top Go down
View user profile
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Tue Mar 06, 2007 5:56 pm

Error: ORA-00918: column ambiguously defined
Cause:
You tried to execute an SQL statement that joined two or more tables, where a column with the same name exists in both tables.
Action: The options to resolve this Oracle error are:
.refix the column with the table name and then re-execute the statement.
Back to top Go down
View user profile
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Tue Mar 06, 2007 6:02 pm

Error: ORA-00919: invalid function
Cause:
You tried to call a function, but the name you used was not a valid Oracle function.
Action: The options to resolve this Oracle error are:
.Correct the spelling of the Oracle function that you wish to call.
.For a complete listing of Oracle functions, go to our Oracle functions webpage.

.Try using the dual table if you wish to call a function without querying a table.
Back to top Go down
View user profile
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Tue Mar 06, 2007 6:05 pm

Error: ORA-00920: invalid relational operator
Cause:
You tried to execute an SQL statement, but the WHERE clause contained an invalid relational operator.
Action: The options to resolve this Oracle error are:
.Correct the WHERE clause. Valid relational operators
Back to top Go down
View user profile
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Tue Mar 06, 2007 6:08 pm

Error: ORA-00923: FROM keyword not found where expected
Cause:
You tried to execute a SELECT statement, and you either missed or misplaced the FROM keyword.
Action: The options to resolve this Oracle error are:
.This error can occur when executing a SELECT statement.
Back to top Go down
View user profile
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Wed Mar 07, 2007 9:52 am

Error: ORA-00924: missing BY keyword
Cause:
You tried to execute a GROUP BY, ORDER BY, CONNECT BY, or GRANT (with IDENTIFIED) statement and missed the BY keyword.
Action: The options to resolve this Oracle error are:
.Try adding the missing BY keyword and re-execute the statement.
Back to top Go down
View user profile
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Wed Mar 07, 2007 9:53 am

Error: ORA-00925: missing INTO keyword
Cause:
You tried to execute an INSERT statement and missed the INTO keyword.
Action: The options to resolve this Oracle error are:
.Try adding the missing INTO keyword and re-execute the statement.
Back to top Go down
View user profile
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Wed Mar 07, 2007 9:54 am

Error: ORA-00926: missing VALUES keyword
Cause:
You tried to execute an INSERT statement and missed the VALUES keyword.
Action: The options to resolve this Oracle error are:
.Try adding the missing VALUES keyword or use a sub-select. Then re-execute the statement.
Back to top Go down
View user profile
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Wed Mar 07, 2007 9:56 am

Error: ORA-00927: missing equal sign
Cause:
You tried to execute a statement, but missed an equal sign. This can happen in either the SET clause of an UPDATE statement or in a search condition.
Action: The options to resolve this Oracle error are:
.If this error occurred in the SET clause of an UPDATE statement, add the missing equal sign and re-execute the statement.
.If this error occurred in a search condition when you are trying to determine a "not equals" condition, add the missing equal sign and re-execute the statement.
Back to top Go down
View user profile
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Wed Mar 07, 2007 9:57 am

Error: ORA-00928: missing SELECT keyword
Cause:
You tried to create a view, but missed the SELECT keyword.
Action: The options to resolve this Oracle error are:
.Correct the CREATE VIEW statement and re-execute it.
Back to top Go down
View user profile
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Wed Mar 07, 2007 9:58 am

Error: ORA-00931: missing identifier
Cause:
This is an internal error message.
Action: The options to resolve this Oracle error are:
.Contact customer support.
Back to top Go down
View user profile
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Wed Mar 07, 2007 9:59 am

Error: ORA-00932: inconsistent datatypes
Cause:
You tried to perform an operation between two different datatypes, but the datatypes are not compatible.
Action: The options to resolve this Oracle error are:
.Correct the operation so that the datatypes are compatible. You may want to use a conversion function such as: to_date, to_number, or to_char. For a complete listing of our Oracle functions, go to our Oracle functions webpage.
.This error can also occur if you try to use an Oracle function on a LONG datatype
Back to top Go down
View user profile
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Wed Mar 07, 2007 10:00 am

Error: ORA-00933: SQL command not properly ended
Cause:
You tried to execute an SQL statement with an inappropriate clause.
Action: The options to resolve this Oracle error are:
.You may have executed an INSERT statement with an ORDER BY Clause. To resolve this, remove the ORDER BY clause and re-execute the INSERT statement.
.You may have tried to execute a DELETE statement with an ORDER BY Clause. To resolve this, remove the ORDER BY clause and re-execute the DELETE statement.
Back to top Go down
View user profile
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Wed Mar 07, 2007 10:01 am

Error: ORA-00934: group function is not allowed here
Cause:
You tried to execute an SQL statement that included one of the group functions (ie: MIN, MAX, SUM, COUNT) in either the WHERE clause or the GROUP BY clause.
Action: The options to resolve this Oracle error are:
.Try removing the group function from the WHERE clause or GROUP BY clause. If required, you can move the group function to the HAVING clause.
.You could also try moving the group by function to a subquery.
Back to top Go down
View user profile
Abhilash

avatar

Number of posts : 228
Age : 34
Registration date : 2007-03-05

PostSubject: Re: Oracle Error Messages   Wed Mar 07, 2007 10:02 am

Error: ORA-00935: group function is nested too deeply
Cause:
This is an internal error message.
Action: The options to resolve this Oracle error are:
.Contact customer support.
Back to top Go down
View user profile
Sponsored content




PostSubject: Re: Oracle Error Messages   

Back to top Go down
 
Oracle Error Messages
Back to top 
Page 2 of 9Go to page : Previous  1, 2, 3, 4, 5, 6, 7, 8, 9  Next
 Similar topics
-
» error messages with internet explorer and USB driver failing to load
» Can I check the error message displayed or not in Selenium?
» Selenium RC; Permission denied on session.([error] Element not found ")
» Getting error when i run selenium script in Eclipse, please help
» Response_Code = -1 Error_Message = Request Error

Permissions in this forum:You cannot reply to topics in this forum
 :: Programming Languages :: ORACLE-
Jump to: