At 02:53 PM 10/27/2000 -0200, Marcos Fabiano Mendes de Siqueira wrote:

>Hello!
>
>What´s a syntax for stored procedure?

In ISQL the syntax for defining a procedure is this:

set term !!;
create procedure <whatever> [(input params)]
[returns (output params)]
as
[variable declarations]
begin
statement;
[statement; ...]
end!!

set term;!!

What are those silly double bangs? The ISQL parser
is unable to distinguish between the semi-colon that
terminates a statement in a procedure declaration and
the one that ends the declaration itself. Set term
tells it to use a different terminator for statements
to be executed by ISQL. The set term statement is
terminated by a semi-colon, of course. Once the
procedure declaration has been made, set term switches
back to a semi-colon terminator - and that statement
is terminated with !!.

Regards,

Ann