Skip to content

PL/SQL scripts produce errors #9

Description

@tsahi

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:

  1. run sqlplus / as sysdba from the command prompt
  2. 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

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    Oraclebugs related to working with Oracle databaseP3Priority 3bugSomething isn't workinghelp wantedExtra attention is needed

    Projects

    No projects

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions