Yes, I have the source of all the stored procedures. But I wanted to understand if it was possible recompile without external resources.
Sometimes I must recompile because other software made a change on a function that has been used inside (a dependences). So it give an error like this "message length error (encountered 16, expected 32776) At procedure '.....')" If I recompile the stored procedure it disappear... Il giorno ven 10 gen 2020 alle ore 15:06 Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] <firebird-support@yahoogroups.com> ha scritto: > 10.01.2020 13:34, Marco Andreolli dra...@gmail.com [firebird-support] > wrote: > > 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 > > If you are the developer of the database you must have full source code > of all procedures. > Otherwise call the developer for them. > > PS: Recompiling of procedures is needed only after migration to different > version of > server which also should be discussed with the developer. > > > -- > 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 > > > >
