Re: Executing dbms_space

Is it a case of assigning variables to the output args before executing the procedure

ie.

execute dbms_space.unused_space('SCOTT', 'EMPLYOEE', 'TABLE',:out1,:out2,:out3....etc)

"M. Bhatti" wrote:

> 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

--
to return e-mail remove NOSPAM from address...... Received on Tue Nov 17 1998 - 15:58:54 CST