Project

General

Profile

Actions

Bug #600

closed

eml-storedProcedure - problems & proposal

Added by David Blankman over 21 years ago. Updated over 21 years ago.

Status:
Resolved
Priority:
Normal
Category:
eml - general bugs
Target version:
Start date:
09/23/2002
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
600

Description

As I began documenting storedProcedure it seemed to me that it is not
appropriately modeled. In eml-view, there is "queryStatement" which allows the
user to provide the sql code necessary to produce the view that is being documented.

In storedProcedure, however, "parameter" replaces queryStatement. In order to
invoke a stored procedure, however, you need more than just the parameters. You
need the name of the storedProcedure or something equivalent to the
queryStatement found in eml-view. I would proposed a structure for
storedProcedure that resembles eml-view.

I am assuming that storedProcedure is meant to apply primarily to a DBMS. If so,
then the storedProcedure syntax and execution must be system specific. If the
intent is to describe the stored procedure, then that should be done in
eml-software.


Files

eml-storedProcedureProposed.xsd (5.31 KB) eml-storedProcedureProposed.xsd David Blankman, 09/23/2002 12:10 PM
eml-storedProcedure.xsd (9.76 KB) eml-storedProcedure.xsd David Blankman, 09/23/2002 01:15 PM
ParameterType2.png (4.42 KB) ParameterType2.png David Blankman, 09/23/2002 04:44 PM
Actions

Also available in: Atom PDF