Oihana PHP System

Procedure

Property keys mapped to the columns of the OpenEdge SQL `SYSPROCEDURES` system catalog table.

SYSPROCEDURES contains one row for each stored procedure defined in the database. Procedure parameter metadata and the source text are stored in the companion tables SYSPROCCOLUMNS and SYSPROCTEXT.

Tags
see
https://docs.progress.com/bundle/openedge-sql-reference/page/SYSPROCEDURES.html
author

Marc Alcaraz (eKameleon)

since
1.0.0

Table of Contents

Constants

NUMBER_OF_ARGUMENTS  : string = 'numberOfArguments'
Number of input/output parameters declared by the procedure (`numargs`).
PROCEDURE_ID  : string = 'procedureId'
Stable identifier assigned to the procedure (`procid`).
PROCEDURE_OWNER  : string = 'procedureOwner'
Owner (SQL schema) of the procedure (`procowner`).
PROCEDURE_TEXT  : string = 'procedureText'
SQL source text of the procedure (`text` / `SYSPROCTEXT`).
REMARKS  : string = 'remarks'
Free-form remarks attached to the procedure (`remarks`).
RETURN_TYPE  : string = 'returnType'
Return type of the procedure, when applicable (`rettype`).

Constants

NUMBER_OF_ARGUMENTS

Number of input/output parameters declared by the procedure (`numargs`).

public string NUMBER_OF_ARGUMENTS = 'numberOfArguments'

PROCEDURE_ID

Stable identifier assigned to the procedure (`procid`).

public string PROCEDURE_ID = 'procedureId'

PROCEDURE_OWNER

Owner (SQL schema) of the procedure (`procowner`).

public string PROCEDURE_OWNER = 'procedureOwner'

PROCEDURE_TEXT

SQL source text of the procedure (`text` / `SYSPROCTEXT`).

public string PROCEDURE_TEXT = 'procedureText'

REMARKS

Free-form remarks attached to the procedure (`remarks`).

public string REMARKS = 'remarks'

RETURN_TYPE

Return type of the procedure, when applicable (`rettype`).

public string RETURN_TYPE = 'returnType'
On this page

Search results