system.storedprocedures

Advantage SQL Engine

Contains one row for each stored procedure in the database.

Field Name

Field Type

Field Size

Description

Name

Character

200

Stored procedure name.

Proc_Input

Memo

variable

Input parameters to the stored procedure in AdsCreateTable format.

Proc_Output

Memo

variable

Output parameters for the stored procedure in AdsCreateTable format.

Proc_DLL_Name

Character

260

The name and path to the Advantage Extended Procedure file that contains the stored procedure, or the ProgID of the COM object for the Extended Procedure.

Proc_DLL_Function_Name

Character

200

The name of the function that is called when the procedure is executed.

Comment

Memo

variable

The description of the stored procedure.

Proc_Invoke_Option

Integer

4

This property is for internal use, and specifies the type of procedure (DLL, COM object, .NET assembly, etc). The constant is based on the constants sent to the AdsDDAddProcedure ACE API in the ulInvokeOption parameter.

SQL_Script

Memo

Variable

Definition of the stored procedure if the stored procedure is an SQL script based stored procedure.