Stored Procedure - error message

[ArnaudAbadie]

I have created the following stored proc

Procedure:
create procedure DupParam(out aram1 integer,in aram2 integer,in aram3 integer,in aram4 integer);
begin
declare :maxkey integer;
insert into param(iDB,iType,iOrder,iLien,sCod,sLib)
select iDB,iType,iOrder,iLien,'Copy'+sCod,'Copy'+sLib from param where iKey = aram2 and iDB = aram3;
select max(iKey) into :maxkey from param;
set aram1=:maxkey;
end;

Error message retrieved:
[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface][Data Record Manager][SPEng][Pervasive][ODBC Engine Erreur SQL general Interface] Non unique table reference: param

Any suggestion would be welcome

 

[Vancouverite]

The problem is the duplicate reference to the param table in the query. Use an Alias on one of the references, e.g.:

insert into param(iDB,iType,iOrder,iLien,sCod,sLib)
select a.iDB, a.iType, a.iOrder, a.iLien, 'Copy'+a.sCod, 'Copy'+a.sLib from param a where a.iKey = aram2 and a.iDB = aram3;