title: ORACLE: ORA-06550 Error at "Select into"
body: <p>I get error ORA-06550 on the SELECT INTO line when executing following SQL:</p>
  
  <pre><code>DECLARE 
    new_type INTEGER;
    cur_idCardProfileId DECIMAL;
  
    CURSOR IDCardProfileCursor
     IS
      SELECT idcardprofileid FROM idcard;    
  BEGIN
    FOR cur_idCardProfileId IN IDCardProfileCursor
    LOOP
      SELECT cardtype INTO new_type FROM idcardprofile WHERE idcardprofileid = cur_idCardProfileId;
    END LOOP;        
  END;
  </code></pre>
  
  <p>Both idcardprofileid (table 'idcard') and idcardprofileid (table 'idcardprofile') are of type DECIMAL.</p>
  
  <p>I got no clue anymore... Thank you in advance.</p>