Hello,
Perhaps you can modify your stored procedure as shown below.
CREATE OR REPLACE PROCEDURE LOGV_SP_INSERTUSER (
i_firstname IN LOGV_USERS.firstname%type,
i_lastname IN LOGV_USERS.lastname%type,
i_username IN LOGV_USERS.username%type,
i_password IN LOGV_USERS.password%type,
i_roleid IN LOGV_USERS.roleid%type,
p_result OUT NUMBER,
p_uid OUT LOGV_USERS.userid%type
)
AS
BEGIN
p_uid := user_seq.nextval;
INSERT INTO LOGV_USERS (
userid,
firstname,
lastname,
username,
password,
roleid
)
VALUES (
p_uid,
i_firstname,
i_lastname,
i_username,
i_password,
i_roleid
);
p_result := sql%rowcount;
END LOGV_SP_INSERTUSER;
Note: I am assuming that the data type for userid is NUMBER.
Regards,