Subject Re: [ib-support] Extracting SP parameters from system tables.
Author Martijn Tonies

> Hello,
> Gurus, help me please. I need to reconstruct compilable SP text from
> database.
> I'm trying to write a tool for applying SP changes from developer's to
> production database.
> How to retrieve SP parameter types (datatype names) from system tables?
> RDB$PROCEDRES.RDB$PROCEDURE source contains only the procedure's body.

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."