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

Unsure, will try tomorrow. Do note, that for example, Oracle allows you to
'save' or 'compile' invalid stored routines > they are stored in the
database
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
http://www.upscene.com

Regards,
Alexey



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