Skip to content
Common PL/SQL utility scripts
PLSQL JavaScript
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Type Name Latest commit message Commit time
Failed to load latest commit information.
build minor Jun 22, 2017
data minor Jun 21, 2017
docs #167 added p_blob_csid tpo blob2clob Sep 2, 2017
install #167 added p_blob_csid tpo blob2clob Sep 2, 2017
source #167 added p_blob_csid tpo blob2clob Sep 2, 2017
tests minor Jun 22, 2017
.gitignore minor Aug 8, 2016
LICENSE Initial commit Apr 23, 2015 info on PRs Jul 7, 2017

OOS Utils

In most applications they're a common set of methods that developers consistently have to re-write. Things such as is_number(p_string), download_file(p_blob), etc. Not only does this add development time to projects, each iteration may have slight differences. The worst is that some of which even have bugs!

Enter OOS Utils. OOS Utils provides a common set of PL/SQL utility methods that remove the need for the creation of common methods in each application. Check out the docs below to see the complete list of methods OOS Utils provides. Never re-develop common methods again!


  • Read The Docs which displays it in a nice, searchable format
  • MD files in the docs folder


For quick install of the latest version of OOS Utils using SQLcl run the following in SQLcl:


If you want to download a copy and install from a local file go to the Install folder for instructions and installation file(s).


If you have a recommendations, please add your idea and/or snippet examples as an issue.

Starting with 1.1.0 all PRs should be the appropriate release branch rather than master.


If you are working on OOS Utils and want to test your build go to the build folder for instructions.

You can’t perform that action at this time.