Re: stored proc assignement

["Johnson, Kate" <JOHNSOK@BESTWESTERN.COM>]

This is unconfirmed (I haven't personally tried this), but
you could try to set the SQR variable within a PL/SQL
script, since SQR allows SQR variables to be assigned
within a PL/SQL script - which is way cool:
    begin-sql
    begin
        $var := sp;;
    end;;
    end-sql

then you can reference $var elsewhere in your code.

> ----------
> From:         Aaron Solomon[SMTP:aaron.solomon@GS.COM]
> Reply To:     SQR-USERS@USA.NET
> Sent:         Thursday, November 06, 1997 10:35 AM
> To:   Multiple recipients of list SQR-USERS
> Subject:      stored proc assignement
>
> I have a stored procedure that performs a select statement.
> I want to include in a script an assignment from this procedure
> to a variable.
>
> I have the line
> LET $var = EXCUTE sp
>
> but sqr doesn't like that.  What am I doing wrong?  Does it need to be
> within
> somekind of special paragraph? HELP!!!
>