Hi,
I am trying to code the following stored procedure, and I need to allow
it to have an input parameter for the UserId, and then get it to
"replace" that record with the data that is passed to it.
Is this close?

SET TERM ^;
CREATE PROCEDURE Replace_User (UserId INTEGER)
(
Id INTEGER,
DisplayName VARCHAR(50),
Email VARCHAR(255),
Extension VARCHAR(100),
Deleted CHAR(1),
)
AS
BEGIN
UPDATE WHERE <-- ? something like where UserId = InputUserId
"Users"
(
"Id",
"DisplayName",
"Email",
"Extension",
"Deleted",
)
VALUES
(
:Id,
:DisplayName,
:Email,
:Extension,
:Deleted,
);
END
^
SET TERM ;^

GRANT UPDATE ON "Users" TO PROCEDURE Replace_User;

GRANT EXECUTE ON PROCEDURE Replace_User TO SYSDBA;

Thanks in advance
--
Richard Mace