| wrong number or types of arguments in call to 'PUT_LINE' [message #35890] |
Mon, 22 October 2001 13:45  |
Dewana
Messages: 6
Registered: October 2001
|
Junior Member |
|
|
Hi,
could please tell what i am doing wrong in the folowing block? It is not letting me print the valuse which I think can be there. if i took out the v_name, v_status, v_size, v_used from OUT_PUT line it runs fine.
Thanks in advance.
Here is the anonymous block
DECLARE
v_Name dba_tablespaces.tablespace_name%type;
v_status dba_tablespaces.status%type;
v_size number(12,3);
v_used number(12,3);
v_used_pct number(5,3);
CURSOR v_tablespace_usage IS
SELECT d.tablespace_name, d.status,
(a.bytes / 1024 / 1024) "SIZE",
(((a.bytes - DECODE(f.bytes, NULL, 0, f.bytes)) / 1024 / 1024)) "USED"
FROM sys.dba_tablespaces d, sys.sm$ts_avail a, sys.sm$ts_free f
WHERE d.tablespace_name = a.tablespace_name
AND f.tablespace_name (+) = d.tablespace_name;
BEGIN
open v_tablespace_usage;
loop
FETCH v_tablespace_usage into v_name, v_status, v_size, v_used;
exit when v_tablespace_usage%notfound;
v_used_pct := ((v_used / v_size) * 100);
DBMS_OUTPUT.PUT_LINE(v_name, v_status, v_size, v_used, v_used_pct);
end loop;
close v_tablespace_usage;
END;
----------------------------------------------------------------------
|
|
|
|
| Re: wrong number or types of arguments in call to 'PUT_LINE' [message #35893 is a reply to message #35890] |
Mon, 22 October 2001 14:06  |
Todd Barry
Messages: 4819
Registered: August 2001
|
Senior Member |
|
|
You'll need to call it with just a single parameter - concatenate your variables using a comma or some other delimiter:
DBMS_OUTPUT.PUT_LINE(v_name || ',' || v_status || ',' || v_size || ',' || v_used || ',' || v_used_pct);
----------------------------------------------------------------------
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
