Sorry I don't understand, is It possible? I would like recompile a stored procedure within a single query or execute block.
I had in mind something with system table but table RDB$PROCEDURES the field RDB$PROCEDURE_SOURCE don't contain the entire procedure but only the body without the parameter. I wouldn't make a more complex query Il giorno ven 10 gen 2020 alle ore 11:35 Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] <firebird-support@yahoogroups.com> ha scritto: > 10.01.2020 09:58, Marco Andreolli dra...@gmail.com [firebird-support] > wrote: > > What is the best way to recompile a stored procedure that has no > dependence on any another > > and without making changes? > > Issue ALTER PROCEDURE statement in WAIT transaction. > > > -- > WBR, SD. > > > ------------------------------------ > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > ------------------------------------ > > Yahoo Groups Links > > > >
