开发者

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);

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜