DbProcedure - do-/node-doix-db GitHub Wiki

DbProcedure is a DbRoutine descendant representing a stored procedure.

Its interface is totally inherited from DbRoutine, without any addition.

As for all DbObject's descendants, instances of this class should only be created by calling DbSchema's create method (normally, in the course of adding).

Sample description

// module.exports = 
{

  label: 'Some stored procedure',

/*
  parameters: [
    'id INT',
    'delta DECIMAL (10,2) = 0',
    'OUT accrued DECIMAL (10,2)',
    {
      name: 'xtra',
      mode: 'INOUT',
      type: 'TEXT',
      default: "''",
    },
  ],
*/

  lang: 'LMNOPQRST',

  body: `
    BEGIN
      /*TODO: implement some feature*/
    END;
  `,

/*
  options: [
    'VENDOR SPECIFIC 1',
    'VENDOR SPECIFIC 2',
  ],
*/
}