Hi to all,

Can anyone tell me what this error message means and how do I fix the
problem.

Thanks heaps in advance.

the error message is reported during a restore of the database

The restore is done using Database WorkBench 2.17.

gbak: restoring index FK_CLIENT_REP_LETTERS
gbak: restoring index FK_COMPANY_LETERS
ERROR: invalid request BLR at offset 917
parameter mismatch for procedure AUTOTEXT_TOWN_DATA

----- the stored procedure in question is following

SET TERM ^^ ;
CREATE PROCEDURE AUTOTEXT_TOWN_DATA (
DETECT_ID BigInt,
STYLE_REQ SmallInt,
TY_REQ SmallInt)
returns (
RESULT_STR VarChar(150) CHARACTER SET ASCII)
AS

declare variable F_Town VarChar(80);
declare variable F_State VarChar(80);
declare variable F_Country VarChar(80);
declare variable F_PCode Integer = 0;
declare variable F_Spacer VarChar(5) = ', ';
declare variable Temo_ID BigInt = 0;
begin

/* get the town ID Number */
if (TY_REQ = 1) then
begin
select TOWNID from COMNAMES where DATATYPE=14364 into :Temo_ID;
end
else if (TY_REQ = 2) then
begin
select TOWN_ID from BUSDETAILS where DETECTID = :DETECT_ID into
:Temo_ID;
end
else if (TY_REQ = 3) then
begin
select TOWNID from CONTACTS where DETECTID = :DETECT_ID into :Temo_ID;
end
else if (TY_REQ = 4) then
begin
select MAILTOWNID from CONTACTS where DETECTID = :DETECT_ID into
:Temo_ID;
end

/* get the town components */
SELECT ITEM001, ITEM002, ITEM003,INT001
FROM D_LIST_HEAD where DETECTID=:Temo_ID
into :F_Town, :F_State, :F_Country,:F_PCode;
/* output the result string */
if (STYLE_REQ = 1) then RESULT_STR = :F_Town;
if (STYLE_REQ = 2) then RESULT_STR = :F_Town
||F_Spacer||:F_State||F_Spacer||cast(:F_PCode as VarChar(10));
if (STYLE_REQ = 3) then RESULT_STR = :F_State;
if (STYLE_REQ = 4) then RESULT_STR = cast(:F_PCode as VarChar(10));
if (STYLE_REQ = 5) then RESULT_STR = :F_Country;

suspend;
end
^^
SET TERM ; ^^

--
Regards,
Grant Brown

Product Development Manager
Phone : 02 4229 1185
Mobile : 0412 926 995
Email : grant@...
Web : www.sitedoc.com.au

SiteDoc - Easy to Use - Powerful Results