Subject Re: [firebird-support] Firebird vs. PostgreSQL
Author Martijn Tonies (Upscene Productions)
Hello Alexey,

>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

Unsure, will try tomorrow. Do note, that for example, Oracle allows you to
'save' or 'compile' invalid stored routines > they are stored in the
anyway and you can ask for a list of errors. In Database Workbench, these
routines are shown in red as to signal they are currently invalid.

>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?

I'll let you know.

With regards,

Martijn Tonies
Upscene Productions


On 07.11.2018 19:27, 'Martijn Tonies (Upscene Productions)'
m.tonies@... [firebird-support] wrote:
> Yes, it's true and it's rather annoying when, for example, developing an
> interactive database development tool;)




Visit and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu

Also search the knowledgebases at


Yahoo Groups Links