Database Toolbox™

procedurecolumns

Get stored procedure parameters and result columns of catalogs

Syntax

pc = procedurecolumns(dbmeta, 'cata', 'sch')
pc = procedurecolumns(dbmeta, 'cata')

Description

• pc = procedurecolumns(dbmeta, 'cata', 'sch') returns the stored procedure parameters and result columns for:

  • The schema sch

  • Of the catalog cata

  • For the database whose database metadata object is dbmeta

• pc = procedurecolumns(dbmeta, 'cata') returns stored procedure parameters and result columns for:

  • The catalog cata

  • For the database whose database metadata object is dbmeta

Running the stored procedure generates results. One row is returned for each column.

Examples

Get stored procedure parameters for:

• The schema ORG

• In the catalog tutorial

• For the database metadata object dbmeta.

pc = procedurecolumns(dbmeta,'tutorial', 'ORG')
pc = 
  Columns 1 through 7
   [1x19 char]   'ORG'   'display'  'Month'   '3' ...
   '12'  'TEXT'
   [1x19 char]   'ORG'   'display'  'Day'     '3' ...
   '4'  'INTEGER'

  Columns 8 through 13
    '50'    '50'    'null'    'null'    '1'    'null'
    '50'     '4'    'null'    'null'    '1'    'null'

The results show stored procedure parameter and result information. Because two rows of data are returned, there are two columns of data in the results. The results show that running the stored procedure display returns the Month and Day columns.

Following is a full description of the procedurecolumns results for the first row (Month).

For more information about the procedurecolumns results, see the getProcedureColumns property on the Sun™ Java™ Web site at http://java.sun.com/j2se/1.4.2/docs/api/java/sql/
DatabaseMetaData.html.

See Also

dmd, get, procedures

primarykeys

procedures