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

Filed under:
|
|

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

Related posts about Oracle

Related posts about plsql