Compartir a través de


getProcedures Method (SQLServerDatabaseMetaData)

Retrieves a description of the stored procedures that are available in the given catalog, schema, or stored procedure name pattern.

public java.sql.ResultSet getProcedures(java.lang.String sCatalog,
                                        java.lang.String sSchema,
                                        java.lang.String proc)

Parámetros

sCatalog

A String that contains the catalog name. Providing a null to this parameter indicates that the catalog name does not need to be used.

sSchema

A String that contains the schema name pattern. Providing a null to this parameter indicates that the schema name does not need to be used.

proc

A String that contains the procedure name pattern.

Valor devuelto

A SQLServerResultSet object.

Excepciones

SQLServerException

Notas

This getProcedures method is specified by the getProcedures method in the java.sql.DatabaseMetaData interface.

The result set returned by the getProcedures method will contain the following information:

Name Type Description

PROCEDURE_CAT

String

The name of the database in which the specified stored procedure resides.

PROCEDURE_SCHEM

String

The schema for the stored procedure.

PROCEDURE_NAME

String

The name of the stored procedure.

NUM_INPUT_PARAMS

int

Reserved for future use, currently returns a -1 value.

NUM_OUTPUT_PARAMS

int

Reserved for future use, currently returns a -1 value.

NUM_RESULT_SETS

int

Reserved for future use, currently returns a -1 value.

REMARKS

String

The description of the procedure column.

Nota

SQL Server does not return a value for this column.

PROCEDURE_TYPE

short

The type of stored procedure. It can be one of the following values:

procedureResultUnknown (0)

procedureNoResult (1)

procedureReturnsResult (2)

Nota

For more information about the data returned by the getProcedures method, see "sp_stored_procedures (Transact-SQL)" in SQL Server Books Online.

Ejemplo

The following example demonstrates how to use the getProcedures method to return information about the uspGetBillOfMaterials stored procedure in the SQL Server 2005 AdventureWorks sample database.

public static void executeGetProcedures(Connection con) {
   try {
      DatabaseMetaData dbmd = con.getMetaData();
      ResultSet rs = dbmd.getProcedures(null, null, "uspGetBillOfMaterials");
      ResultSetMetaData rsmd = rs.getMetaData();

      // Display the result set data.
      int cols = rsmd.getColumnCount();
      while(rs.next()) {
         for (int i = 1; i <= cols; i++) {
            System.out.println(rs.getString(i));
         }
      }
      rs.close();
   } 

   catch (Exception e) {
      e.printStackTrace();
   }
}

Vea también

Referencia

SQLServerDatabaseMetaData Class

Conceptos

SQLServerDatabaseMetaData Methods
SQLServerDatabaseMetaData Members