>>Marcos,

>>You need to post the source code for the stored procedure. I've seen this error when you try to select a 64-bit integer >>into an integer type variable, or a BLOB into a varchar variable.

>>Helen

Ok. There is. This procedure check to see if all of my triggers are ok before launch the application. At same time, I return what triggers are not ok in vOk parameter. When vOk returns empty, then all triggers are ok. An trigger is ok when it exists and is active.


create procedure TRIGGERCHECK returns (vOk varchar(255)) as
declare variable vRows integer;
begin
select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_ITEMENTR' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_ITEMENTR ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_ITEMENTR' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_ITEMENTR ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_ITEMSAI' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_ITEMSAI ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_ITEMSAI' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_ITEMSAI ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TD_ITEMSAI' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_ITEMSAI ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TD_ITEMSAI' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_ITEMSAI ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_SAIDA' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_SAIDA ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_SAIDA' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_SAIDA ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_SAIDA' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_SAIDA ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_SAIDA' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_SAIDA ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TD_SAIDA' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_SAIDA ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TD_SAIDA' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_SAIDA ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_COMPRA' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_COMPRA ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_COMPRA' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_COMPRA ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_COMPRA' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_COMPRA ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_COMPRA' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_COMPRA ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_ITEMCOMP' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_ITEMCOMP ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_ITEMCOMP' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_ITEMCOMP ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TD_ITEMCOMP' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_ITEMCOMP ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TD_ITEMCOMP' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_ITEMCOMP ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_ITEMVEND' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_ITEMVEND ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_ITEMVEND' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_ITEMVEND ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_ITEMVEND' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_ITEMVEND ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_ITEMVEND' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_ITEMVEND ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TD_ITEMVEND' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_ITEMVEND ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TD_ITEMVEND' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_ITEMVEND ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_ENTRADA' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_ENTRADA ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_ENTRADA' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_ENTRADA ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_ENTRADA' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_ENTRADA ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_ENTRADA' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_ENTRADA ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TD_ENTRADA' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_ENTRADA ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TD_ENTRADA' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_ENTRADA ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_ITEMENTR' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_ITEMENTR ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_ITEMENTR' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_ITEMENTR ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TD_ITEMENTR' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_ITEMENTR ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TD_ITEMENTR' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_ITEMENTR ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_ITEMAJU' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_ITEMAJU ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_ITEMAJU' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_ITEMAJU ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_ITEMAJU' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_ITEMAJU ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_ITEMAJU' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_ITEMAJU ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TD_ITEMAJU' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_ITEMAJU ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TD_ITEMAJU' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_ITEMAJU ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_OPERACAO' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_OPERACAO ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_OPERACAO' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_OPERACAO ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_MERCADOR' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_MERCADOR ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_MERCADOR' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_MERCADOR ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_MERCADOR' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_MERCADOR ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_MERCADOR' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_MERCADOR ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_INVENTAR' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_INVENTAR ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_INVENTAR' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_INVENTAR ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_INVENTAR' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_INVENTAR ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_INVENTAR' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_INVENTAR ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_CHEQUE' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_CHEQUE ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_CHEQUE' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_CHEQUE ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_CHEQUE' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_CHEQUE ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_CHEQUE' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_CHEQUE ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TD_CHEQUE' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_CHEQUE ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TD_CHEQUE' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_CHEQUE ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_BAIXAPAG' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_BAIXAPAG ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_BAIXAPAG' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_BAIXAPAG ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TD_BAIXAPAG' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_BAIXAPAG ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TD_BAIXAPAG' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_BAIXAPAG ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_BAIXAPAG' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_BAIXAPAG ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_BAIXAPAG' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_BAIXAPAG ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_BAIXAREC' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_BAIXAREC ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_BAIXAREC' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_BAIXAREC ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TD_BAIXAREC' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_BAIXAREC ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TD_BAIXAREC' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_BAIXAREC ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_BAIXAREC' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_BAIXAREC ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_BAIXAREC' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_BAIXAREC ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_PAGAR' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_PAGAR ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_PAGAR' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_PAGAR ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_PAGAR' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_PAGAR ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_PAGAR' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_PAGAR ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TD_PAGAR' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_PAGAR ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TD_PAGAR' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_PAGAR ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_RECEBER' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_RECEBER ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_RECEBER' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_RECEBER ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_RECEBER' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_RECEBER ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_RECEBER' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_RECEBER ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TD_RECEBER' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_RECEBER ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TD_RECEBER' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_RECEBER ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_CONFIGUR' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_CONFIGUR ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_CONFIGUR' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_CONFIGUR ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_PRODUTO' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_PRODUTO ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_PRODUTO' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_PRODUTO ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_PRODUTO' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_PRODUTO ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_PRODUTO' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_PRODUTO ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TD_PRODUTO' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_PRODUTO ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TD_PRODUTO' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_PRODUTO ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_LANCAMENTO' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_LANCAMENTO ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_LANCAMENTO' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_LANCAMENTO ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_LANCAMENTO' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_LANCAMENTO ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_LANCAMENTO' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_LANCAMENTO ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TD_LANCAMENTO' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_LANCAMENTO ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TD_LANCAMENTO' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_LANCAMENTO ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_PESSOAFI' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_PESSOAFI ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_PESSOAFI' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_PESSOAFI ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_PESSOAFI' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_PESSOAFI ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_PESSOAFI' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_PESSOAFI ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_PESSOAJU' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_PESSOAJU ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_PESSOAJU' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_PESSOAJU ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_PESSOAJU' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_PESSOAJU ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_PESSOAJU' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_PESSOAJU ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_EMPRESA' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_EMPRESA ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_EMPRESA' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_EMPRESA ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_EMPRESA' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_EMPRESA ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_EMPRESA' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_EMPRESA ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_PESSOA' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_PESSOA ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_PESSOA' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_PESSOA ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_CONTA' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_CONTA ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_CONTA' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_CONTA ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_CONTA' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_CONTA ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_CONTA' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_CONTA ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TD_CONTA' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_CONTA ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TD_CONTA' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_CONTA ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_PARCFATURA' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_PARCFATURA ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_PARCFATURA' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_PARCFATURA ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_PARCENTRADA' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_PARCENTRADA ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_PARCENTRADA' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_PARCENTRADA ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_VENDA' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_VENDA ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_VENDA' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_VENDA ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_VENDA' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_VENDA ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_VENDA' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_VENDA ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_CLASSEICMS' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_CLASSEICMS ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_CLASSEICMS' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_CLASSEICMS ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_CLASSEICMS' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_CLASSEICMS ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_CLASSEICMS' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_CLASSEICMS ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TD_CLASSEICMS' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_CLASSEICMS ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TD_CLASSEICMS' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TD_CLASSEICMS ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TU_SOCIO' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_SOCIO ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TU_SOCIO' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TU_SOCIO ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_SOCIO' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_SOCIO ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_SOCIO' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_SOCIO ';

select count(*) from RBD$TRIGGERS where RDB$TRIGGER_NAME = 'TI_ITEMSAI' into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_ITEMSAI ';
else
select count(*) from RDB$TRIGGERS where RDB$TRIGGER_NAME = 'TI_ITEMSAI' and RDB$TRIGGER_INACTIVE = 0 into :vRows;
if (vRows = 0) then
vOk = vOk || 'TI_ITEMSAI ';

end

----- Original Message -----
From: Helen Borrie
To: ib-support@yahoogroups.com
Sent: Saturday, April 28, 2001 11:12 AM
Subject: Re: [ib-support] Invalid request BLR


At 09:03 AM 28-04-01 -0300, you wrote:
>Hi. I'm get an error when I compile an stored procedure: "Invalid request BLR at offset 17075. Context not defined (BLR error)." Anybody knows why/when this error occurs?
Marcos,

You need to post the source code for the stored procedure. I've seen this error when you try to select a 64-bit integer into an integer type variable, or a BLOB into a varchar variable.

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________

Yahoo! Groups Sponsor



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]