Subject | Re: [IBO] Extracting stored procedure code |
---|---|
Author | Paul Vinkenoog |
Post date | 2003-05-29T21:47:20Z |
Hi Clément,
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
> Is there a way to extract a procedure code using IBO?Build a query based upon this:
> I saw the IB_DDL_Extract component, but it extracts all the
> procedures. I would like to extract just one.
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