Subject | Re: [firebird-support] Re: Returning values from stored procedure |
---|---|
Author | Helen Borrie |
Post date | 2003-07-12T14:24:25Z |
At 04:14 PM 12/07/2003 +0200, you wrote:
you don't put the selected values into return parameters for working on
them within the procedure. Notice that I did recommend that this guy
should RTFM.
heLen
>Another thing. Helen wrote:Paul, only in the context of the question - emphasis to make it clear that
>
> > create procedure dosomething (<input-list)
> > /* __EITHER__ make a returns-list if you want to output a set */
> > returns (var1 sometype, var2 othertype, var3 anothertype, var5 sometype)
> >
> > AS
> >
> > /* __OR__ declare local variables to execute STUF on the server */
> > declare variable var1 sometype;
> > declare variable var2 othertype;
> > ...etc.....
>
>This surprised me because it looked as if she said categorically you
>have to choose between a returns-list and local variables. I don't
>think she really meant that (maybe the caps made it look extra heavy
>;-)), but just to make sure you don't get the wrong impression:
you don't put the selected values into return parameters for working on
them within the procedure. Notice that I did recommend that this guy
should RTFM.
heLen