Article · Wikipedia archive · Last revised Jun 12, 2026

Ruby-plsql-spec

Ruby-plsql-spec is a modern PL/SQL unit testing framework, based on the Ruby testing framework.

Last revised
Jun 12, 2026
Read time
≈ 1 min
Length
169 w
Citations
6
Source
Wikipedia ↗
Ruby-plsql-spec
Original authorRaimonds Simanovskis
Preview release
0.5.0 / May 13, 2016 (2016-05-13)
Written inRuby
TypeSQL test automation framework
LicenseMIT
Repositorygithub.com/rsim/ruby-plsql-spec

Ruby-plsql-spec is a modern PL/SQL unit testing framework, based on the Ruby testing (or behaviour driven development) framework.1

It was originally developed to give PL/SQL developers an alternative to the utPLSQL framework. The goal was to make it faster to write Unit testing easier and less verbose.2

Features

The key features of Ruby-plsql-spec include:

  • Provides a Ruby API for calling PL/SQL procedures and functions, supporting various PL/SQL data types as input and output parameters.3
  • Allows writing unit tests for PL/SQL code in Ruby using the RSpec syntax, which is more compact and readable compared to traditional PL/SQL testing frameworks.4
  • Includes helper methods and utilities for creating test data and verifying results.1
  • Supports running tests against an Oracle database connection specified in a configuration file.1
References

References

  1. "rsim/ruby-plsql-spec". GitHub. Retrieved 2016-03-14.
  2. Simanovskis, Raimonds. "Oracle PL/SQL unit testing with Ruby". blog.rayapps.com. Retrieved 2016-03-14.
  3. Simanovskis, Raimonds (2023-07-25), rsim/ruby-plsql, retrieved 2024-07-03
  4. "PL/SQL unit testing with Ruby". SlideShare. 2010-05-20. Retrieved 2024-07-03.