-
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 ?
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.
-
you have to tell SQL*Plus to display the output using the command ...
set serveroutput on
... then execute your block.
-
Thanks
Thanks your right! ....duh ..I appreciate that
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|