Re: Stored Procedure with different SUMs - STATIC SQL

I hear you can test getting the results back from a stored procedure with
iNav's Run SQL Scripts. How can you
- Create a procedure using the line below
- test it and see the result sets
from within Run SQL Scripts?

I try this in RSS and get

create procedure rob.x
(in parm1 int,
out parm2 char( 1 ))
language sql
begin
select * from rob.ttable
where ( ((parm1=1) and (territory=1)) or (territory in (select territory
from terrtable)) );
end;

SQL State: 42601
Vendor Code: -29
Message: [SQL0029] INTO clause missing from embedded statement. Cause . .
. . . : SELECT and VALUES INTO statements embedded in a program must
have an INTO clause to specify where the results of the statement are to
be placed. Recovery . . . : Add the INTO clause to the statement and
try the request again.


Rob Berendt