Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Error starting at line : 17 in command -
- INSERT INTO STUDENT VALUES ('Smith', 17, 1, 'CS')
- Error report -
- SQL Error: ORA-12899: value too large for column "SYSTEM"."STUDENT"."STUDENT_NUMBER" (actual: 2, maximum: 1)
- 12899. 00000 - "value too large for column %s (actual: %s, maximum: %s)"
- *Cause: An attempt was made to insert or update a column with a value
- which is too wide for the width of the destination column.
- The name of the column is given, along with the actual width
- of the value, and the maximum allowed width of the column.
- Note that widths are reported in characters if character length
- semantics are in effect for the column, otherwise widths are
- reported in bytes.
- *Action: Examine the SQL statement for correctness. Check source
- and destination column data types.
- Either make the destination column wider, or use a subset
- of the source column (i.e. use substring).
- Error starting at line : 18 in command -
- INSERT INTO STUDENT VALUES ('Brown', 8, 2, 'CS')
- Error report -
- SQL Error: ORA-00001: unique constraint (SYSTEM.SYS_C007131) violated
- 00001. 00000 - "unique constraint (%s.%s) violated"
- *Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
- For Trusted Oracle configured in DBMS MAC mode, you may see
- this message if a duplicate entry exists at a different level.
- *Action: Either remove the unique restriction or do not insert the key.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement