At 11:24 AM 9/12/2004 +0100, you wrote:

>Thanks Hellen for your help, I will try to rebuild the procedure to avoid such
>surprises in future.
>
>One more question:
>
> > CREATE PROCEDURE MGP_PZ2PROT_REKL (
> > SRV VARCHAR (3),
> > PZ_ID INTEGER)
> > RETURNS (
> > PR_ID INTEGER)
> > AS
> >
> >
> > END
> > suspend;
> > This is an executable SP and suspend should not be there.
> > end
>
>Even if I want to get pr_id value back to the application?

Yes. The return value[s] from an executable procedure is [are] a
singleton. Your asking that question prompts me to wonder whether you are
trying to use a SELECT statement to execute your executable procedure...

./helen