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!

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
Post Details
Added on Jul 29 2022
4 comments
257 views