Hi I'm creating a PL/SQL Procedure in Oracle 9i. I need to display the contents of a table onto the screen from within my Procedure. If I simply issue a 'SELCT * FROM tablename' it gives an error that the statement requires a SELECT INTO clause. Can anyone tell me how to just dump the contents of the table onto the screen from that code block? Many thanks,
Well I guess I figured out the answer to my own question... Issue the select statement after the 'END' command... just in case anyone else wants to know.