Subject Re: [IBO] Extracting stored procedure code
Author Paul Vinkenoog
Hi Clément,

> Is there a way to extract a procedure code using IBO?
> I saw the IB_DDL_Extract component, but it extracts all the
> procedures. I would like to extract just one.

Build a query based upon this:

select rdb$procedure_source
from rdb$procedures
where rdb$procedure_name = ...

This gives the procedure source. To get the complete picture, check
the number of in/out params and get their names and types from
rdb$procedure_parameters. I'll leave it to you to work that out.
It's not difficult, just look in rdb$procedures and
rdb$procedure_parameters and you will see the Light :-)

Greetings,
Paul Vinkenoog