Executing dbms_space

From: M. Bhatti <mohammed.bhatti_at_mci.com>
Date: Tue, 17 Nov 1998 18:13:41 GMT
Message-ID: <3651BD9F.363B1F4F@mci.com>

I'm trying to execute the dbms_space.unused_space procedure but keep getting errors.

This is how I'm executing the sp on a Sun Solaris 2.5.1 and Oracle 7.3.2.3:

SQL> execute dbms_space.unused_space('SCOTT', 'EMPLYOEE', 'TABLE'); begin dbms_space.unused_space('SCOTT', 'EMPLYOEE', 'TABLE'); end;

      *
ERROR at line 1:

ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'UNUSED_SPACE'
ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

I've looked at the prototype for the sp and it asks for 3 IN params and returns 7 OUT params. So I should only be supplying the 3 IN params, right?

The procedure is defined as follows:
procedure unused_space(segment_owner IN varchar2,

                         segment_name IN varchar2,
                         segment_type IN varchar2,
                         total_blocks OUT number,
                         total_bytes OUT number,
                         unused_blocks OUT number,
                         unused_bytes OUT number,
                        unused_blocks OUT number,
                         unused_bytes OUT number,
                         last_used_extent_file_id OUT number,
                         last_used_extent_block_id OUT number,
                         last_used_block OUT number
                         );

Any ideas what I'm doing wrong?

Thanks

mkb Received on Tue Nov 17 1998 - 12:13:41 CST