Open
Description
Describe the bug
some of the Oracle scripts in the test projects produce errors when created. The error is "Warning: Procedure created with compilation errors."
The scripts are:
- ADDCOUNTRYLISTALL.prc
- DELETECOUNTRYLISTALL.prc
- GETCUSTOMERBYID.prc
- GETCUSTOMEROUT.prc
- GETCUSTOMERSANDPRODUCTSVIEW.prc
- GETCUSTOMERSVIEW.prc
- GETPRODUCTSVIEW.prc
- UPDATECOUNTRYLISTALL.prc
and are located in /BVT/Data.BVT/DatabaseSetupScripts/OracleDBScripts/3.SP
the script BVT/Data.BVT/DatabaseSetupScripts/OracleDBScripts/4.Data/alldata.sql produces many "unique constraint (SYS.PK_CUSTOMERID) violated" errors.
To Reproduce
Steps to reproduce the behavior:
- run
sqlplus / as sysdba
from the command prompt - for each of the scripts listed above, run the script using
> @<full path to script>
.
Expected behavior
every script should be executed with the message "Procedure created."
Context (please complete the following information):
- OS: Windows
- DB: Oracle XE 18c