|
|
|
|
|
|
|
|
|
version 1.5
OC GET PROCEDURE LIST (cursor_ID; db_Array; owner_Array; proc_Array; type_Array)
| Parameter | Type | Description | |
| cursor_ID | Longint |  | Cursor ID |
| db_Array | String Array |  | List of database names |
| owner_Array | String Array | | List of owner names |
| proc_Array | String Array | | Names of the procedures |
| type_Array | String Array | | List of procedure types |
Description
The OC GET PROCEDURE LIST command enables you to obtain a list of stored procedures on the ODBC data source.
cursor_ID must be the ID of a previously created and inactive cursor.
db_Array is the name of a string array that will accept the list of database names where the procedures reside.
owner_Array is the name of a string array that will accept the list of owner names for the procedures.
proc_Array is the name of a string array that will accept the names of the procedures.
type_Array is the name of a string array that will accept the values of the list of procedure types.
Example
The following method loads the list of stored procedures into arrays:
ARRAY STRING(30;arDB;0)
ARRAY STRING(30;arOwn;0)
ARRAY STRING(30;arProc;0)
ARRAY STRING(30;arType;0)
If(arTab#0)
OC GET PROCEDURE LIST(cur_id;"arDB";"arOwn";"arProc";"arType")
Else
ALERT("select a table in the table name array !")
End if
|
|
|
|
|
|
|
|
|