Hello,
Is it possible to select a list of read only stored procedures from the
database.
I'd like to give my reporting engine access to stored procedures where they
fit the following rules
1.) Must be selectable
2.) Must have no input parameters.
3.) Must have one or more output parameters.
4.) Must not perform any database writes either directly or indirectly (via
another procedure call.)
I have 1-3 sorted with the following SQL but I can't see if 4 is possible. Can
anyone point me in the right direction please?
select
rdb$procedures.*
from rdb$procedures
where
coalesce(rdb$procedures.rdb$procedure_inputs,0)=0
and
rdb$procedures.rdb$procedure_type = 1
and
rdb$procedures.rdb$procedure_outputs >0
Many thanks,
Will.
