1     create table #oledb_results_table(-- 0 Rows, Data: 0 B, Index: 0 B
2         PROCEDURE_CATALOG varchar(32) null,
3         PROCEDURE_SCHEMA varchar(32) null,
4         PROCEDURE_NAME varchar(255) null,
5         PARAMETER_NAME varchar(255) null,
6         ORDINAL_POSITION smallint null,
7         PARAMETER_TYPE smallint null,
8         PARAMETER_HASDEFAULT bit not null,
9         PARAMETER_DEFAULT varchar(255) null,
10        IS_NULLABLE bit not null,
11        DATA_TYPE smallint null,
12        CHARACTER_MAXIMUM_LENGTH int null,
13        CHARACTER_OCTET_LENGTH int null,
14        NUMERIC_PRECISION smallint null,
15        NUMERIC_PRECISION_RADIX smallint null,
16        NUMERIC_SCALE smallint null,
17        DESCRIPTION varchar(255) null,
18        TYPE_NAME varchar(32) null,
19        LOCAL_TYPE_NAME varchar(32) null
20    )
21    

DEPENDENCIES

READERS AND WRITERS read_written by proc sybsystemprocs..sp_oledb_getprocedurecolumns