Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Need to raise application error with duplicate value.

Hi Team,
I am trying to insert from select statement from one table to other table. while insert there is primary key so need to raise application error what all duplicate values in that table.
Example attached script. pls help for the same.
Answers
-
Hi, @User_JIAY3
Whenever you have a question, please post a little sample data (CREATE TABLE and INSERT statements for all tables involved, relevant columns only) so the people who want to help you can re-create the problem and test their ideas. Also post the exact results you want from that data, and explain why you want those results from that data. In this case, you should include some INSERT or UPDATE statements that should cause the error, and show exactly what you want to happen as a result. Always post your complete Oracle version (e.g. 18.4.0.0.0). Post everything right in this space. Do not use attachments; not all the poeple who want to help you can or will open attachments.
there is primary key so need to raise application error what all duplicate values in that table.
Oracle will raise an error if anyone tries to violate a PRIMARY KEY or UNIQUE constraint; you don't need to do anything special. If you really want to raise an application-specific error instead, you can use an EXCEPTION handler to check for the Oracle-defined error, and raise the application-specific error instead.
-
Hi Frank, Already attached the same data and pkg also. can you possiable to share.
-
Hi Frank, there were some more content so that i attached. why i used the raise application since it should comeout of the package.
-
Hi, @User_JIAY3
Already attached the same data and pkg also. can you possiable to share.
Exactly; you attached it; that's the problem. Don't use attachments: post everything right in this space.