Advertisement
Guest User

Untitled

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