You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for DUP_VAL_ON_INDEX


1 to 11 of 11 results.


User's Guide and Reference, 9i Release 2 (9.2.0.2)

Handling PL/SQL Errors

Handling Exceptions Raised in Handlersraise DUP_VAL_ON_INDEX WHEN DUP_VAL_ON_INDEX THEN... -- cannot catch the exception END;

Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

Database Concepts

Using PL/SQL… ..... EXCEPTION WHEN DUP_VAL_ON_INDEX THEN ROLLBACK; END; END-EXEC....

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Database Concepts

Using PL/SQLDUP_VAL_ON_INDEX THEN ROLLBACK;... END; END-EXEC;... Copyright © 1996, 2002 Oracle Corporation. All Rights

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Handling PL/SQL Errors

Retrying a Transaction(name, ans1, ans2, ans3); -- raises DUP_VAL_ON_INDEX if two respondents have the same name COMMIT; EXIT … ; EXCEPTION WHEN DUP_VAL_ON_INDEX THEN ROLLBACK TO start_transaction; -- undo changes suffix

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Interaction Between PL/SQL and Oracle

Undoing Partial Changes with SAVEPOINTstore a duplicate value in the empno column, the predefined exception DUP_VAL_ON_INDEX is raised. In … ; INSERT INTO emp VALUES (emp_id,...); EXCEPTION WHEN DUP_VAL_ON_INDEX THEN ROLLBACK TO do_insert; END

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Interaction Between PL/SQL and Oracle

Undoing Changes with ROLLBACKstatement tries to store a duplicate employee number, the predefined exception DUP_VAL_ON_INDEX is raised … ,...);... EXCEPTION WHEN DUP_VAL_ON_INDEX THEN ROLLBACK;... END; Statement-Level Rollbacks Before

Advanced Replication, 9i Release 2 (9.2.0.2)

Conflict Resolution Concepts and Architecture

Uniqueness Conflicts Resolution Methodstransaction to the replicated column value that is generating a dup_val_on_index exception. Although this … is generating a dup_val_on_index exception. Although this method allows the column to be inserted or

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Sample PL/SQL Programs

PL/SQL BlockCURRENT OF c1; EXCEPTION WHEN DUP_VAL_ON_INDEX THEN -- account already exists UPDATE accounts SET bal

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Handling PL/SQL Errors

Predefined PL/SQL ExceptionsDUP_VAL_ON_INDEX ORA-00001 -1 INVALID_CURSOR ORA-01001 -1001 INVALID_NUMBER ORA-01722 -1722 LOGIN_DENIED … , your program cannot open that cursor inside the loop. DUP_VAL_ON_INDEX Your program attempts to store

Programmer's Guide to the Oracle Precompilers 1.8 Go to Contents for this book, 9i Release 2 (9.2.0.2)

Defining and Controlling Transactions

Using PL/SQLDUP_VAL_ON_INDEX THEN ROLLBACK; END; END-EXEC;... Copyright © 1996-2001, Oracle Corporation. All Rights

Reference Guide for Informix Dynamic Server Migrations, 9i Release 2 (9.2.0.2)

Triggers, Packages, and Stored Procedures

Individual SPL StatementsInformix Dynamic Server Error Number Oracle Predefined Exception -239 DUP_VAL_ON_INDEX 100 … DUP_VAL_ON_INDEX THEN /* Not Converted: -310 */ RETURN - 2; END; END add_slist_thing; RAISE EXCEPTION Statements