Wordpress Themes - Wordpress Themes - Flash Games - Novated lease - Kamala

PDA

View Full Version : PL/SQL - Oracle


skimmy
Feb 13th 2006, 3:25 pm
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,

skimmy
Feb 13th 2006, 4:01 pm
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.