|Subject||List of read only stored procedures.|
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?
rdb$procedures.rdb$procedure_type = 1