Procedure not printing anything
CREATE OR REPLACE PROCEDURE proc AS
CURSOR v_cursor IS
BEGIN
FOR obj IN v_cursor LOOP
dbms_output.put_line(obj.player ||' '|| obj.No ||' ');
END LOOP;
END;
This is the procedure that i have written.... When i comile开发者_开发百科 it the procedure gets created but when i try and execute the procedure....
Procedure succesfully completed but nothing prints....
Would appreciate the help...!!!
Cheers
Edit: The query runs fine and i get the desired result...!!!
Two things:
1) Check if your query is indeed returning some rows.
2) Make sure SERVEROUT IS ON (SET SERVEROUTPUT ON) or use dbms_output.enable(buffer_size => NULL);
精彩评论