PL/SQL problem
From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Mon, 02 Aug 1999 21:38:27 GMT
Message-ID: <37a60f60.19261602_at_news.earthlink.net>
declare
i number;
k number;
type var_record is record
(user manager_close.user_id%type,
var number);
[Quoted] [Quoted] 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;
PL/SQL: SQL Statement ignored
Date: Mon, 02 Aug 1999 21:38:27 GMT
Message-ID: <37a60f60.19261602_at_news.earthlink.net>
declare
i number;
k number;
type var_record is record
(user manager_close.user_id%type,
var number);
[Quoted] [Quoted] 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 emailReceived on Mon Aug 02 1999 - 23:38:27 CEST