I updated from dotConnect for Oracle 9.4.326 to 9.5.429.
With the new version, I have a problem with an migration, that was working fine before. My migration contains some GRANT SQL statements like
Code: Select all
Sql("GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE TO CLIENT_USER");
Code: Select all
Update-Database -Verbose -ProjectName Qm.Tda.Dal -ConnectionString "xxx" -ConnectionProviderName "Devart.Data.Oracle"
Using StartUp project 'Qm.Tda.Api'.
Specify the '-Verbose' flag to view the SQL statements being applied to the target database.
Target database is: '' (DataSource: localoracle, Provider: Devart.Data.Oracle, Origin: Explicit).
Applying explicit migrations: [...].
Applying explicit migration: xxx.
GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE TO CLIENT_USER
Devart.Data.Oracle.OracleException (0x80004005): ORA-01003: no statement parsed
at Devart.Data.Oracle.cr.d()
at Devart.Data.Oracle.d2.o()
at Devart.Data.Oracle.d2.a()
at Devart.Data.Oracle.d3.a()
at Devart.Data.Oracle.d4.a(d2 A_0, Int32 A_1)
at Devart.Data.Oracle.d4.a(Int32 A_0, eb A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
Greetings
Peter