Fix error program with dapper ORM

I have a code which occur error , anyone help me.
I use database Oracle v19
My code :
var query = "INSERT INTO ToolFileHistory(FileName, FileType,Purpose,UploadedDate,UserId) VALUES(:FileName, :FileType,:Purpose,:UploadedDate,:UserId)";

var dp = new DynamicParameters();
dp.Add("@FileName", fullFileName);
dp.Add("@FileType", file.ContentType);
dp.Add("@Purpose", FilePurposeEnum.CompareEmployeeWorkStatus.ToInt());
dp.Add("@UploadedDate", DateTime.Now);
dp.Add("@UserId", 4);

var result = _dbConn.ExecuteScalar(query, dp);
Code can write into database but i need get identity of row which just inserted . (looklike SCOPE_INDENTITY of SQL server)

Anyone help me to fix this bug .
Thank you so much.