promises_ninja

Summary

Promises ninja is an attempt at implementing the javascript Promises A+ definition in pl/sql.

Pre-requisites

The following privileges are needed:

• create session

• create type

• create procedure

• aq_administrator_role

• create job

• execute on dbms_aq

• execute on dbms_aqadm

Installation

To install the promises_ninja package run the following scripts in order:

promises_aq_job_object.sql

promises_aq_object.sql

promises_list.sql

promises_list_object.sql

promises_aq_asyn_queue.sql

promises_aq_queue.sql

promises_job_notify_run.procedure.sql

promises_notify.job.sql

promises_ninja.type.sql

promises_ninja.package.sql

promises_ninja.type.body.sql

promises_ninja.package body.sql

Procedures and Functions

Examples