| Subject | Re: [firebird-support] How to get datatype of stored procedures from system tables |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2005-02-19T21:37:59Z |
Bob Murdoch wrote:
RDB$FIELDS where the datatype information is stored. RDB$TYPES will
translate from the numbers to strings. (7 = char, 14 = varchar)
Regards,
Ann
> I can query system tables to get a list of stored procedures and theirThe field RDB$FIELD_SOURCE in RDB$PROCEDURE_PARAMETERS is a key into
> parameter names. Is there a way to obtain the datatype of the
> procedure as well?
>
RDB$FIELDS where the datatype information is stored. RDB$TYPES will
translate from the numbers to strings. (7 = char, 14 = varchar)
Regards,
Ann