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: 290
        
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