Category: PL/SQL

ORA-00955: name is already used by an existing object Oracle PL/SQL error message: ORA-00955: name is already used by an existing object. Cause: An attempt was made to create a database object (table, view, cluster, index, or synonym) that already exists. Solution: Check the database object name and enter a unique name or modify or…(Continue Reading)

ORA-00925: missing INTO keyword Oracle PL/SQL error message: ORA-00925: missing INTO keyword. Cause: The INSERT statement has been entered without the keyword INTO. Solution: On the INSERT statement add the keyword INTO and then retry the statement. Example: Insert COURSE (COURSE_ID,NAME,DESCRIPTION,DURATION,PRICE) values (6,’Java’,’Java course 1′,’12 weeks’,200); Output: ORA-00925: missing INTO keyword Correct: Insert INTO COURSE…(Continue Reading)

ORA-00908: missing NULL keyword Oracle PL/SQL error message: ORA-00908: missing NULL keyword. Cause: Either of the following: In a CREATE TABLE or ALTER TABLE statement, NOT was entered to specify that no null values are allowed in that column, but the keyword NULL was omitted. In the IS [NOT] NULL logical operator, the keyword NULL…(Continue Reading)

Oracle PL/SQL error message: ORA-20000: ORU-10027: buffer overflow, limit of 20000 bytes. This error indicates that a buffer overflow has occurred, and the size of the data being processed has exceeded the predefined limit of 20000 bytes. Cause: The stored procedure ‘raise_application_error’ was called which causes this error to be generated. Let’s break down the…(Continue Reading)

ORA-00979: not a GROUP BY expression Oracle PL/SQL error message: ORA-00979: not a GROUP BY expression. Cause: The GROUP BY clause does not contain all the expressions in the SELECT clause. SELECT expressions that are not included in a group function(like AVG, COUNT, MAX, MIN, SUM, STDDEV or VARIANCE) must be listed in the GROUP…(Continue Reading)