We are trying to execute the SP which resides in the package of oracle 11g. As of now we don't have any issues by querying the tables directly but we are facing issues while executing the SP from the package.
Error details:- "ORA-00900: invalid SQL statement"
Get connection string :
services.AddDbContext(options=>options.UseOracle(Configuration.GetConnectionString("DefaultConnection")));
callingSP from package .
Var list = _context.GetResultdetails.FromSqlRaw ("BEGIN Package.uspGetdetailsSP(:vrAccessID,:results); END;", parameters).ToList();
Fetching data from table
var a = _context.species.FromSqlRaw("select * from DetailDB.table;").ToList()