Simple question - can't find answer

How do I return a set of data from a stored procedure? Basically all I want to do is return the results of a select query which will contain multiple rows. This does not work in informix, it gives error #659. I know it basically means i have to select the result into another table, but then how does that actually get returned? CREATE PROCEDURE test() SELECT * FROM table END PROCEDURE

zackary.evans@gmail.com said: > How do I return a set of data from a stored procedure? Basically all I > want to do is return the results of a select query which will contain > multiple rows. > > This does not work in informix, it gives error #659. I know it > basically means i have to select the result into another table, but > then how does that actually get returned? > > CREATE PROCEDURE test()> > SELECT * > FROM table> > END PROCEDURE RETURN? -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine Normile