How to catch a unique constraint error in a PL/SQL block?

by 
EXCEPTION
      WHEN DUP_VAL_ON_INDEX
      THEN
         UPDATE

Related Contents:

  1. Number of rows affected by an UPDATE in PL/SQL
  2. PL/SQL, how to escape single quote in a string?
  3. Oracle PL/SQL – How to create a simple array variable?
  4. Printing the value of a variable in SQL Developer
  5. Oracle SQL Query for listing all Schemas in a DB
  6. How can I drop a “not null” constraint in Oracle when I don’t know the name of the constraint?
  7. Oracle PL/SQL – Raise User-Defined Exception With Custom SQLERRM
  8. How do I get column datatype in Oracle with PL-SQL with low privileges?
  9. How to execute an oracle stored procedure?
  10. Get a list of all functions and procedures in an Oracle database
  11. Functions vs procedures in Oracle
  12. BEGIN – END block atomic transactions in PL/SQL
  13. Truncating a table in a stored procedure
  14. Oracle: how to INSERT if a row doesn’t exist
  15. Can you SELECT everything, but 1 or 2 fields, without writer’s cramp?
  16. Declaring a variable and setting its value from a SELECT query in Oracle
  17. Convert comma separated string to array in PL/SQL
  18. How to redirect the output of DBMS_OUTPUT.PUT_LINE to a file?
  19. Get resultset from oracle stored procedure
  20. Get counts of all tables in a schema
  21. Passing an array of data as an input parameter to an Oracle procedure
  22. Difference between a user and a schema in Oracle?
  23. What is the difference between varchar and varchar2 in Oracle?
  24. ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
  25. Boolean Field in Oracle
  26. What is the Oracle equivalent of SQL Server’s IsNull() function?
  27. How do I use CREATE OR REPLACE?
  28. Difference between oracle DATE and TIMESTAMP
  29. What is the difference between “AS” and “IS” in an Oracle stored procedure?
  30. Oracle client ORA-12541: TNS:no listener [closed]
  31. How to display databases in Oracle 11g using SQL*Plus
  32. Oracle: how to find out storage space used by a table?
  33. How to find the privileges and roles granted to a user in Oracle? [duplicate]
  34. how to modify an existing check constraint?
  35. How to see if the background process is complete in SQLDEVELOPER
  36. How to rename a table column in Oracle 10g
  37. ORA-01461: can bind a LONG value only for insert into a LONG column-Occurs when querying
  38. Is there a free GUI management tool for Oracle Database Express? [closed]
  39. how to modify the size of a column
  40. No more data to read from socket error
  41. HQL “is null” And “!= null” on an Oracle column
  42. ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
  43. Oracle – What TNS Names file am I using?
  44. How to get UTC value for SYSDATE on Oracle
  45. How can I issue a single command from the command line through sql plus?
  46. URL string format for connecting to Oracle database with JDBC
  47. Oracle: sequence MySequence.currval is not yet defined in this session
  48. How to test an Oracle Stored Procedure with RefCursor return type?
  49. What can cause intermittent ORA-12519 (TNS: no appropriate handler found) errors
  50. NULL or BLANK fields (ORACLE)

Leave a Comment