Skip to content

PL/SQL scripts produce errors #9

Open
@tsahi

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

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