Subject Re: [IBO] Extracting stored procedure code
Author Clément Doss
That did it.. Thanks!

But ... (you saw that one coming, didn't you?)
I have declared a parameter as being NUMERIC(15,2) and in rdb$procedure_parameters is
shows as (DOUBLE, 8 , -2). You can check it in employee.gdb. IBConsole shows as
NUMERIC(15,2) but the table shows DOUBLE , 8 , -2...

Best regards,
Clément

Paul Vinkenoog wrote:
> Oh, by the way:
>
>
>>...just look in rdb$procedures and rdb$procedure_parameters...
>
>
> Maybe this isn't clear enough. If you don't know the above tables,
> they are system tables (created automatically in every IB/FB database)
> and most tools don't show them by default, but you can make them
> appear by checking a box that is typically called "Show system info"
> or something the like.
>
> You can browse and query them like any other table, but you should
> never insert, update or delete something in that region if you don't
> know exactly what you're doing.
>
> Grtz,
> Paul
>