| Subject | Extracting SP parameters from system tables. | 
|---|---|
| Author | Andrew Guts | 
| Post date | 2003-02-17T11:15:56Z | 
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.
Thanks
Andrew
            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.
Thanks
Andrew