GetOracleFields()
Summary
Gets a list of fields in an Oracle table and whether they are indexed.
Syntax
Field_list = GetOracleFields(string table_name, string owner_name, string service_name)
| Argument | Contents |
|---|---|
| table_name | The name of the Oracle table |
| owner_name | The name of the owner |
| service_name | The name of the Oracle service |
Returns
An array of two elements:
| Element | Type | Contents |
|---|---|---|
| 1 | Array | An array of field names (strings) |
| 2 | Array | An array of strings indicating whether the fields are indexed, with the values "No", "Yes", "Unique" and "Primary" ("Unique" means that each value is unique, "Primary" indicates this is the primary key for the table) |
Error Codes
| Error Type | Meaning |
|---|---|
| Error | An error occurred while connecting to the given Oracle service |
| NotFound | The specified table does not exist in the Oracle service |
See Also
| Function | Summary |
|---|---|
| GetOracleTables() | Gets a list of Oracle tables available to the user |