| Subject | Re: call stored procedure from another one. |
|---|---|
| Author | mcnamara_gio |
| Post date | 2008-10-02T12:08:31Z |
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
PROCEDURE .... RETURNING_VALUES(:outvar1, :outvar2, ....)
>the called procedure as an executable one and call it with EXECUTE
> At 19:30 2/10/2008, you wrote:
>
> >Thanks it worked. But it is very slow.
>
> Using a SELECT procedure is not a sensible way to do this. Rewrite
PROCEDURE .... RETURNING_VALUES(:outvar1, :outvar2, ....)
>Can you show me an example how to do it?
> .heLen
>