Subject Can I retreive parameters from a stored procedure? Part 2
Author Softtech Support
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 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]