DBMS_OUTPUT question .....

[ripcurl]

This is driving me nuts ...I'm not getting any output but I'm getting succesfull PL/SQL...what am I doing wrong ?



1 declare
2 todays_date DATE;
3 BEGIN
4 todays_date := SYSDATE;
5 DBMS_OUTPUT.PUT_LINE('Today''s date is ' || TO_CHAR(todays_date));
6 END;
SQL> /

PL/SQL procedure successfully completed.

[slimdave]

you have to tell SQL*Plus to display the output using the command ...

set serveroutput on

... then execute your block.

[ripcurl]

Thanks your right! ....duh ..I appreciate that