DBMS_OUTPUT question .....
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: DBMS_OUTPUT question .....

  1. #1
    Join Date
    Apr 2003
    Posts
    2

    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.

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    you have to tell SQL*Plus to display the output using the command ...

    set serveroutput on

    ... then execute your block.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Apr 2003
    Posts
    2

    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
  •  



Click Here to Expand Forum to Full Width