fluentmigrator: Execute.Sql() cannot execute stored procedure with Oracle runner

Describe the bug

Not able to execute stored procedure in Oracle using Fluent Migrator

Steps to reproduce

A standalone project replicating the issue can be found here.

Load the package
Update the connection string in MigrationRun.cs
Run MigrateRun_Up.bat from the command prompt.

Expected behavior

Stored procedure should be executable from within Fluent Migrator.

Screenshots

Environment

  * Oracle.ManagedDataAccess v18.6.0
  * FluentMigrator v3.2.1
 * FluentMigrator.Runner.Oracle v3.2.1
  * Windows 10
  * Oracle 11.2.0.4

Additional context

See M0001_CreateMemberTable for details. Stored procedure can be run successfully using EXEC CREATE_INDEX without Fluent Migrator, but for some reason doesn’t work when it is wrapped in an Execute.Sql() method.

About this issue

Original URL
State: closed
Created 4 years ago
Comments: 17 (1 by maintainers)

Most upvoted comments

@PhenX you rock!

jzabroski on Feb 17, 2020

@jzabroski It works! Sorry we didn’t try this in the first place. FAQ away - thanks for the great support on this! 😃

kriewall on Feb 17, 2020

@jzabroski Thanks for getting back with me - we’ll try out some of your content above and try again to get it to work on our end. We too have a lot going on at the moment without even becoming Oracle Certified, so we might be a little slow to get back as well. Race ya! 😃

kriewall on Feb 11, 2020