Java.Sql.IDatabaseMetaData.GetProcedureColumns Method
Returns a list of parameter and result columns for the stored procedures belonging to a specified catalog.

Syntax

[Android.Runtime.Register("getProcedureColumns", "(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet;", "GetGetProcedureColumns_Ljava_lang_String_Ljava_lang_String_Ljava_lang_String_Ljava_lang_String_Handler:Java.Sql.IDatabaseMetaDataInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public IResultSet GetProcedureColumns (string catalog, string schemaPattern, string procedureNamePattern, string columnNamePattern)

Parameters

catalog
a catalog name. null is used to imply no narrowing of the search by catalog name. Otherwise, the name must match a catalog name held in the database, with "" used to retrieve those without a catalog name.
schemaPattern
a schema name pattern. null is used to imply no narrowing of the search by schema name. Otherwise, the name must match a schema name in the database, with "" used to retrieve those without a schema name.
procedureNamePattern
a pattern that must match the name of the procedure stored in the database.
columnNamePattern
a column name pattern. The name must match the column name stored in the database.

Returns

Documentation for this section has not yet been entered.

Exceptions

TypeReason
Java.Sql.SQLExceptiona database error occurred.

Remarks

Returns a list of parameter and result columns for the stored procedures belonging to a specified catalog.

The list is returned as a ResultSet with one row for each parameter or result column. The data is ordered by PROCEDURE_SCHEM and PROCEDURE_NAME, while for each procedure, the return value (if any) is first, followed by the parameters in the order they appear in the stored procedure call, followed by ResultSet columns in column number order. Each row has the following structure:

  1. PROCEDURE_CAT - String - the procedure catalog name
  2. PROCEDURE_SCHEM - String - the procedure schema name (possibly null)
  3. PROCEDURE_NAME - String - the procedure name
  4. COLUMN_NAME - String - the name of the column
  5. COLUMN_TYPE - short - the kind of column or parameter, as follows:
    • DatabaseMetaData.procedureColumnUnknown - type unknown
    • DatabaseMetaData.procedureColumnIn - an IN parameter
    • DatabaseMetaData.procedureColumnInOut - an INOUT parameter
    • DatabaseMetaData.procedureColumnOut - an OUT parameter
    • DatabaseMetaData.procedureColumnReturn - a return value
    • DatabaseMetaData.procedureReturnsResult - a result column in a result set
    • DATA_TYPE - int - the SQL type of the data, as in java.sql.Types
    • TYPE_NAME - String - the SQL type name, for a UDT it is fully qualified
    • PRECISION - int - the precision
    • LENGTH - int - the length of the data in bytes
    • SCALE - short - the scale for numeric types
    • RADIX - short - the Radix for numeric data (typically 2 or 10)
    • NULLABLE - short - can the data contain null:
      • DatabaseMetaData.procedureNoNulls - NULLs not permitted
      • DatabaseMetaData.procedureNullable - NULLs are permitted
      • DatabaseMetaData.procedureNullableUnknown - NULL status unknown
      • REMARKS - String - an explanatory comment about the data item

      [Android Documentation]

      Requirements

      Namespace: Java.Sql
      Assembly: Mono.Android (in Mono.Android.dll)
      Assembly Versions: 0.0.0.0
      Since: Added in API level 1