Get stored procedure parameters' type -

I need to read the parameter type of procedures stored in the Firebird database.

I am capable if they are input or output parameters, then read their names, but where can I get their type? Or how do you solve it?

You must use a combination of RDB $ PROCEDURE_PARAMETERS and RDB $ FIELDS view, as shown below:

  select rdb $ process_name, rdb $ process_parameters.rdb $ parameter_name, rdb $ fields.rdb $ fields_name, rdb $ Fields.rdb $ rdb from $ function_type_immeter, rdb $ fields WHERE rdb $ fields.rdb $ field_name = rdb $ process_parameters.rdb $ field_source  

Field type value in RDB is $ FIELDS as follows Defined:

 BLOB - 261 CHAR - 14 Seating - 40 d_flot - 11 double - 27flow T - 10 INNT 64 - 16 Integer - 8 Quad - 9 Smalling - 7 Date - 12 Time - 13 TIMESTAMP - 35 VARCHAR - 37 

For more information about these types of definitions, see Interface language reference .