This discussion is archived
1 Reply Latest reply: Mar 24, 2013 4:48 PM by Srini Chavali-Oracle RSS

Not getting output

998860 Newbie
Currently Being Moderated
The staements under DBMS_OUTPUT.PUT_LINE are not getting executed. It only shows the messege 'PL/SQL procedure successfully completed"
For example,
SQL>DECLARE
2 v_num NUMBER:=2;
3 BEGIN
4 DBMS_OUTPUT.PUT_LINE('NUM:'||v_num);
5 END;
6 /
PL/SQL procedure successfully completed.
SQL>
like this it does not show output. The display procedure does not executed.
wht to do for this problem?????

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points