Essa "FUNÇÂO DELPHI" abaixo está retornando da minha procedure do 
firebird o parametro "IN_TABLE" quando na verdade deveria devolver o 
parametro "COD". Não entendo !!! Alguem pode me ajudar ?

//MINHA PROCEDURE NO FIREBIRD
CREATE PROCEDURE SP_IFTABEXIST (IN_TABLE VARCHAR(10))
RETURNS (COD INTEGER)
AS
BEGIN
SELECT COUNT(RDB$RELATION_NAME) FROM rdb$RELATION_FIELDS
WHERE RDB$RELATION_NAME = :IN_TABLE into :COD;
END

//FUNÇÂO DELPHI
begin
//Preparando Database
    mdtbs1.Connected := false;
    mdtbs1.DatabaseName := 'c:\f.fdb';
//Preparando Stored
    mdstrdprc1.StoredProcName := 'SP_IFTABEXIST';
    mdtbs1.Connected := True;
//Parametros de envio
    if mdstrdprc1.Params.Count > 0 then
    begin
      mdstrdprc1.Prepare;
      for i := 0 to mdstrdprc1.ParamCount - 1 do
      begin
        mdstrdprc1.Params[i].Value := Parametros.Strings[i];
      end;
    end;
//Execultando Procedure
    mdstrdprc1.ExecProc;

//Parametros de Retorno
    for i := 0 to mdstrdprc1.Params.Count - 1 do
     lbl1.Caption := mdstrdprc1.Params.ParamByName(mdstrdprc1.Params
[i].Name).AsString);

end;



Responder a