PL/SQL problem

From: NetComrade <>
Date: Mon, 02 Aug 1999 21:38:27 GMT
Message-ID: <>

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;
  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;
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 - 23:38:27 CEST

Original text of this message