I'm getting a error message when my users try to save changes: INSERT ERROR - SQLCA.sqlcode -1. The front-end app is Power Builder and backend is Oracle 8.1.7. How can I correct this problem and is the correct in PowerBuilder or oracle? thanks in advance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
INSERT ERROR - SQLCA.SQLCODE -1
- Thread starter theinvid
- Start date
Oracle error -1 is "unique contraint violated", meaning your Powerbuilder app is trying to insert a duplicate unique key row in the table. You need to correct your application so that it does not attempt to insert duplicate rows, or else handles the error in a more user-friendly fashion.
This error more commonly manifests itself in SQL sessions as ORA-00001.
This error more commonly manifests itself in SQL sessions as ORA-00001.
- Status
