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.
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 site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.