declare
i number;
k number;
type var_record is record
(user manager_close.user_id%type,
var number);
type var_record_table is table of var_record index by binary_integer;
var_table var_record_table;
begin
i:=dbms_utility.get_time;
select user_id, nvl(count(*),0) into var_table from manager_close
where when_closed = '13-JUL-99' group by user_id;
k:=dbms_utility.get_time;
dbms_output.put_line(k-i);
end;
ORA-06550: line 11, column 1:
PLS-00393: wrong number of columns in SELECT...INTO statement
ORA-06550: line 11, column 1:
PL/SQL: SQL Statement ignored
What am I doing wrong? Thanx.
Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
AOL: NetComrade ICQ: 11340726 remove NSPAM to email
Received on Mon Aug 02 1999 - 16:38:27 CDT
