Migration to 11.2 ok, 10.2 gives ORA-06550

[Remco Blok]

Hello,

When I apply my EF Code First Migrations to an Oracle 11.2 database everything goes fine. When I apply the same migrations to an Oracle 10.2 database I get the following error at the point when the migration tries to insert a record with a large blob into the __MigrationHistory table. Can you help please?

thanks

Remco

Devart.Data.Oracle.OracleException (0x80004005): ORA-06550: line 8, column 5:
PLS-00103: Encountered the symbol "" The symbol "" was ignored.
at Devart.Data.Oracle.t.d()
at Devart.Data.Oracle.at.h()
at Devart.Data.Oracle.at.c()
at Devart.Data.Oracle.aa.a(Int32 A_0, bw 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)
at Devart.Data.Oracle.OracleCommand.ExecuteNonQuery()
at System.Data.Entity.Migrations.DbMigrator.ExecuteSql(DbTransaction transaction, MigrationStatement migrationStatement)
at System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.ExecuteSql(DbTransaction transaction, MigrationStatement migrationStatement)
at System.Data.Entity.Migrations.DbMigrator.ExecuteStatements(IEnumerable`1 migrationStatements)
at System.Data.Entity.Migrations.Infrastructure.MigratorBase.ExecuteStatements(IEnumerable`1 migrationStatements)
at System.Data.Entity.Migrations.DbMigrator.ExecuteOperations(String migrationId, XDocument targetModel, IEnumerable`1 operations, Boolean downgrading)
at System.Data.Entity.Migrations.DbMigrator.ApplyMigration(DbMigration migration, DbMigration lastMigration)
at System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.ApplyMigration(DbMigration migration, DbMigration lastMigration)
at System.Data.Entity.Migrations.DbMigrator.Upgrade(IEnumerable`1 pendingMigrations, String targetMigrationId, String lastMigrationId)
at System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.Upgrade(IEnumerable`1 pendingMigrations, String targetMigrationId, String lastMigrationId)
at System.Data.Entity.Migrations.DbMigrator.Update(String targetMigration)
at System.Data.Entity.Migrations.Infrastructure.MigratorBase.Update(String targetMigration)
at System.Data.Entity.Migrations.Design.ToolingFacade.UpdateRunner.RunCore()
at System.Data.Entity.Migrations.Design.ToolingFacade.BaseRunner.Run()
ORA-06550: line 8, column 5:
PLS-00103: Encountered the symbol "" The symbol "" was ignored.

[Shalex]

Please send us the following information:
1) the exact (x.xx.xxx) build of your dotConnect for Oracle. Have you tried the latest (7.0.6) version?
2) the version (x.xx.xxx) of EntityFramework.dll you are using
3) a small test project to reproduce the issue in our environment