DBMS_OUTPUT question .....
This is driving me nuts ...I'm not getting any output but I'm getting succesfull PL/SQL...what am I doing wrong ?
2 todays_date DATE;
4 todays_date := SYSDATE;
5 DBMS_OUTPUT.PUT_LINE('Today''s date is ' || TO_CHAR(todays_date));
PL/SQL procedure successfully completed.
you have to tell SQL*Plus to display the output using the command ...
set serveroutput on
... then execute your block.
Thanks your right! ....duh ..I appreciate that
Click Here to Expand Forum to Full Width