oracle collection not enough values
Posted
by john
on Stack Overflow
See other posts from Stack Overflow
or by john
Published on 2010-06-13T16:25:19Z
Indexed on
2010/06/13
16:32 UTC
Read the original article
Hit count: 239
I did following:
create or replace type my_row as object
(
lname varchar2(30),
fname varchar2(30),
MI char(1),
hohSSN char (9),
hohname VARCHAR2(63),
hohDob char(10),
dob DATE
);
create or replace type eiv.my_rec as table of eiv.my_row;
but then doing query like:
my_records my_rec
select '', '', '', '', '', '', sysdate bulk collect into my_records from dual;
gives error ORA-00947: not enough values
what can i be doing wrong here?
© Stack Overflow or respective owner