Nando,

> Martijn,
>
> M> CREATE PROCEDURE CALL_TEST returns (
> M> POOUT Integer)
> M> AS
> M> begin
> M> POOUT = 1;
> M> end
> M> ^^
> M> SET TERM ; ^^
>
> M> commit;
>
> M> select * from call_test
>
> -->> no rows returned.
>
> as I said already, this (a returns clause and no suspend) is a
> programmer error. Roman is not looking for ways to turn a badly coded
> SP into legal code.

No, he isn't. He is looking for a code to call procedures the right way.
The problem is: you cannot DETECT the right way.

>I think perhaps I'd need some examples of SPs and
> calls to fully understand where Roman is stuck precisely.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com