This stored procedure is just to demonstrate a problem.
create or replace PROCEDURE SP_TEST_CSHARP (word IN varchar2,upperword OUT varchar2) AS
begin
select upper(word) into upperword from dual;
end;
I created this model,
public partial class rsProcedure {
public string upperword{ get; set; }
}
I tried this:
OracleParameter word = new OracleParameter("word",OracleDbType.Varchar2, ParameterDirection.Input);
word.Value = "marcio"; OracleParameter upperword = new OracleParameter("upperword",OracleDbType.Varchar2, ParameterDirection.Output);
var result = _dbContext.rsProcedures.FromSqlRaw("begin SP_TEST_CSHARP(:word, :upperword); end;", word, upperword);
So i get this error message:
System.InvalidOperationException: The required column 'upperword' was not present in the results of a 'FromSql' operation.
Could anyone tell me what I'm doing wrong?
Thank you very much