Re: Stored Procedure with different SUMs - STATIC SQL

[rob@xxxxxxxxx]

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