Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Need to raise application error with duplicate value.

User_JIAY3Jul 29 2022

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.
createing_pkg.rar (630 Bytes)

Comments

Processing

Post Details

Added on Jul 29 2022
4 comments
218 views