Search code examples
c#sqlplsqlentity-framework-4

Error refreshing materialized view from a stored procedure (not a valid month)

I am trying to refresh a materialized view from a stored procedure, I command to call the procedure from csharp but when refreshing the view it sends me the error: ORA-12008: error in materialized view refresh path, followed by: ORA-01843: not a valid month, I've tried it with another view and yes it's refreshing, any help for this detail?

attached image

enter image description here

This is my code:

I am not passing parameters and neither dates, I am just trying to refresh the view from C # visual studio

  string oradb = "Data Source=DATA; User Id=DATA; Password=DATA;";
            OracleConnection conn = new OracleConnection(oradb);
            conn.Open();
            OracleCommand cmd = conn.CreateCommand();
            cmd.CommandType = System.Data.CommandType.StoredProcedure;
            cmd.CommandText = "ACTUALIZA_VISTAS_VRE";
            //cmd.CommandText = "exec REFRESH_RECUPERADO";
            cmd.ExecuteNonQuery();
            conn.Close();
Solution

  • The stored procedure or materialized view is where the code is that is providing the invalid month. Is ACTUALIZA_VISTAS_VRE calling REFRESH_RECUPERADO?