procedurecolumns (Database Toolbox)

Get catalog's stored procedure parameters and result columns

Syntax

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

Description

pc = procedurecolumns(dbmeta, 'cata') returns the stored procedure parameters and result columns for the catalog cata, for the database whose database metadata object is dbmeta, which was created using dmd.

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, which was created using dmd.

MATLAB returns one row for each column in the results generated by running the stored procedure.

Examples

Type

pc = procedurecolumns(dbmeta,'tutorial', 'ORG')

where:

dbmeta is the database metadata object.
tutorial is the catalog cata.
ORG is the schema sch.

MATLAB returns

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 the stored procedure parameter and result information. Because two rows of data are returned, there will be two columns of data in the results when you run the stored procedure. From the results, you can see that running the stored procedure display returns the Month and Day. 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'

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
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/DatabaseMetaData.html for the getProcedureColumns property.

See Also
dmd, get, procedures

primarykeys procedures