Alexey I can confirm that it is possible to 'compile' SP with error that will appear during SP execution. Probably the most annoying thing in the world for Firebird users ;-) I hate it.
Marcin ------ Wiadomość oryginalna ------ Od: "Alexey Kovyazin a...@ib-aid.com [firebird-support]" <firebird-support@yahoogroups.com> Do: firebird-support@yahoogroups.com Data: 07.11.2018 17:37:00 Temat: Re: [firebird-support] Firebird vs. PostgreSQL >Martijn, > >What about compilation of stored procedures - is it true that it is >possible to create SP with errors, and they appear only when it will be >invoked? > >Also, about checking the parameters - is it true that you can create >stored procedure which invokes other stored procedure with wrong list >of >parameters, and it will give error only at the execution time? > >Regards, >Alexey > > > >On 07.11.2018 19:27, 'Martijn Tonies (Upscene Productions)' >m.ton...@upscene.com [firebird-support] wrote: >>Yes, it's true and it's rather annoying when, for example, developing >>an >>interactive database development tool;) > > > >------------------------------------ > >------------------------------------ > >++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > >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 > > >