forked from microsoftarchive/data-access-application-block
-
Notifications
You must be signed in to change notification settings - Fork 0
Open
Labels
Oraclebugs related to working with Oracle databasebugs related to working with Oracle databaseP3Priority 3Priority 3bugSomething isn't workingSomething isn't workinghelp wantedExtra attention is neededExtra attention is needed
Milestone
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 sysdbafrom 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
Metadata
Metadata
Assignees
Labels
Oraclebugs related to working with Oracle databasebugs related to working with Oracle databaseP3Priority 3Priority 3bugSomething isn't workingSomething isn't workinghelp wantedExtra attention is neededExtra attention is needed