plsql - getting ORA-06550 error - 


declare   type v_year_arr varray(100) of emps%rowtype;   v_deptid emps.department_id%type :=90;   v_rem1 number(5,2);   v_rem2 number(5,2);     v_rem3 number(5,2);   v_year v_year_arr; begin    select * bulk collect v_year emps department_id = v_deptid;    v_rem1 := mod(v_year.yof,4);    v_rem2 := mod(v_year.yof,100);    v_rem3 := mod(v_year.yof,400);    i..v_year loop       if (v_rem1=0 , v_rem2=0 , v_rem3=0)               dbms_output.put_line('leap year :'||v_year.yof);       else         dbms_output.put_line('not leap year :'||v_year.yof)       end if;    end loop; end;

i think you'd better off writing using cursor loop, in:

declare   v_deptid emps.department_id%type :=90;   v_rem1 number(5,2);   v_rem2 number(5,2);     v_rem3 number(5,2); begin   arow in (select * emps department_id = v_deptid)   loop     v_rem1 := mod(arow.yof,4);     v_rem2 := mod(arow.yof,100);     v_rem3 := mod(arow.yof,400);      if (v_rem1=0 , v_rem2<>0) or (v_rem2=0 , v_rem3=0)       dbms_output.put_line('leap year :'||arow.yof);     else       dbms_output.put_line('not leap year :'||arow.yof)     end if;   end loop; end;

this eliminates potential problem of having more 100 rows returned select...bulk collect into... statement. took liberty of correcting leap year determination.

share , enjoy.


Comments

Post a Comment

Popular posts from this blog

matlab - Deleting rows with specific rules -

i got 20*3 cell array , need delete rows contains "137", "2" , "n:t" origin data: 't' '' '' 'np(*)' '' '' [ 137] '' '' [ 2] '' '' 'are' 'and' 'np(fcc_a1#1)' '' '' '1:t' [ 1200] [0.7052] '' [1.2051e+03] [0.7076] '' 'are' 'and' 'np(fcc_a1#3)' '' '' '2:t' [ 1200] [0.0673] '' [1.2051e+03] [0.0671] '' 'are' 'and' 'np(m23c6)' '' '' '3:t' [ 1200] [0.227...
Read more

php - MySQLi multi_query results for later use -

i using mysqli multi_query work several select statemets @ time. know how handle results, able use them later in code. example: <?php //connection stuff $query = "select name, surname database1;"; $query.= "select car, year, type database2 carid='1';"; $query.= "select product, price database3;"; if ($mysqli->multi_query($query)) { if($result = $mysqli->store_result()) { while($row = $result->fetch_row()) { --> here? } } } ?> <html> <div id='persona'> <?php foreach() { --> print name + surname } ?> </div> <div id='cars'> <?php foreach() { --> print car + year + type } ?> </div> <div id='product'> <?php foreach() { --> print product + price } ?> </div> </html> one more thing, prepared statements not possible when using multiple_query, right? there no benefit in putting unrelated queries in 1 multi ...
Read more