Stack Overflow
Stack Overflow

Questions tagged [utplsql]

Use this tag for questions relating to writing PL/SQL unit tests using the utPLSQL framework.

utPLSQL is a PL/SQL implementation of the venerable JUnit unit testing framework. It was originally written by Steven Feuerstein. The current version 3 is actively developed and maintained by a team of passionate developers. Find it here

21 questions
0
votes
1 answer

Ut PL SQL to test stored procedure

I'm new to UT PLSQL. We have a existing application which contains of lots of stored procedures. Most of the procedures at the end insert or update values to tables. Is there any way in utplsql to test these table values?? I can see lot of examples…
Joshua
  • 3
  • 1
0
votes
1 answer

Why utplsql-cli command throws error with Hikari pool only after sqlplus commands?

when executing utplsql-cli command I've successfully connected to the db and all tests were executed. Unfortunately, when executing any sqlplus commands before, then utplsql-cli throws error: Successfully connected to database. UtPLSQL core:…
pwoj
  • 1
  • 3
0
votes
1 answer

How to execute utplsql for collection data type

I want support to handle collection datatype in ut_expect in utplsql. I want to do the testing of below package using utplsql. I want to check the date array. create or replace PACKAGE pkg_BA_GetAccrualHist AS TYPE arr_start_date IS TABLE OF…
python lover
  • 65
  • 6
0
votes
1 answer

utPLSQL: Test using an existing table

There's a table named summary_table which compares two tables and checks if those two table's columns, constraints and data are same or not. One of the table being checked(table1) is the first version and another(table2) is the second. The summary…
Success Shrestha
  • 433
  • 1
  • 4
  • 19
0
votes
3 answers

utPLSQL: How can i compare two tables?

Lets say i have table 1 and table 2. Table 2 is the updated version of table one. It can have same or updated structure, columns and data. I want to compare those two tables.
Success Shrestha
  • 433
  • 1
  • 4
  • 19
0
votes
2 answers

utPLSQL - Add individual test results into a table

How can I add an individual test result into a table. I want it in this format: test_desc | status -------------------------------- this is test 1 | Pass -------------------------------- this is test 2 | Fail
Success Shrestha
  • 433
  • 1
  • 4
  • 19
1
2