procedurecolumns - Get stored procedure parameters and result columns of catalogs

Syntax

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).

Column	Description	Value for First Row
1	Catalog	'D:\orgdatabase\orcl'
2	Schema	'ORG'
3	Procedure name	'display'
4	Column/parameter name	'MONTH'
5	Column/parameter type	'3'
6	SQL data type	'12'
7	SQL data type name	'TEXT'
8	Precision	'50'
9	Length	'50'
10	Scale	'null'
11	Radix	'null'
12	Nullable	'1'
13	Remarks	'null'

For more information about the procedurecolumns results, see the getProcedureColumns property on the Sun Java Web site:

http://java.sun.com/j2se/1.4.2/docs/api/java/sql/
DatabaseMetaData.html

See Also

dmd | get | procedures

© 1984-2012- The MathWorks, Inc.    -   Site Help   -   Patents   -   Trademarks   -   Privacy Policy   -   Preventing Piracy   -   RSS