I have a stored procedure that have two variables. I need to do some
operations with their, and put the result in a table. Whats wrong in
my example? (this is not the complete code). An error is generated in
this operation: (qtd_minuto * qtd_modulo)/60)


declare variable qtd_modulo smallint;
declare variable qtd_minuto smallint;

.....

insert into DISCIPLINA_HISTORICO (ID_DISCIPLINA, CARGA_HORARIA)
values (:disciplina,((qtd_minuto * qtd_modulo)/60) );
The column CARGA_HORARIA is NUMERIC(5,2).