DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Visualization of dbms_olap.estimate_summary_size output

  1. #1
    Join Date
    Nov 2000
    Posts
    6

    Exclamation

    How can I visualize dbms_olap.estimate_summary_size output? I run the following code under sqlplus:

    1 DECLARE
    2 num_rows number;
    3 num_bytes number;
    4 BEGIN
    5 --dbms_olap.estimate_summary_size('pippo','select * from cat',num_rows,num_bytes);
    6 dbms_output.put(num_rows);
    7 --dbms_output.new_line;
    8 --dbms_output.put(num_bytes);
    9 dbms_output.new_line;
    10* end;

    but I had only 'PL/SQL procedure successfully completed'.
    How can I visualize num_rows? Thanks

    Vincenzo


  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You have to issue:
    set serveroutput on

    in sqlplus before you start your PL/SQL block.
    Jeff Hunter

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