How do I determine what type the parameter is? Is it a date, or a varchar
Any help with this appreciated.
Thanks,
Mike
I figured it out...
SELECT P.RDB$PARAMETER_NUMBER,
P.RDB$PARAMETER_NAME
FROM RDB$PROCEDURE_PARAMETERS P
WHERE P.RDB$PROCEDURE_NAME = 'SPS_COTM_ACTIVITY_RPT'
AND
Hello Mike,
if I remember correctly, the parameters of a stored procedure are also
handeled as system domains. The name of that domain can be found in the
RDB$FIELD_SOURCE column of RDB$PROCEDURE_PARAMETERS. So - with
RDB$FIELD_SOURCE, you can ask RDB$FIELDS for the domain definition:
select RDB$