Returning results from a Stored procedure

Are these types of statement possible from within an SP: SELECT col1, col2 FROM Table1;
?
Ie. would it produce the same result as executing it from within SqlPlus

SqlPlus gives me an error when i try to compile. Unless, i've cludged up the syntax. I doesn't seem possible.

Is there another way to return result-sets from SP:s

/Regards Received on Sun Oct 24 1999 - 14:57:05 CDT