[firebird-support] Can I retreive parameters from a stored procedure? Part 2

[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]