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 P.RDB$PARAMETER_TYPE = 0

----- Original Message -----
From: Softtech Support
To: Firebird Support
Sent: Friday, May 03, 2013 8:55 AM
Subject: Can I retreive parameters from a stored procedure?


Greetings All,

Firebird v1.53

I need to programatically (Using Delphi) retreive the input parameters from a stored procedure. Is this possible?

Thanks,
Mike

[Non-text portions of this message have been removed]