$impl procedures which are migrated from Oracle Functions RRS feed

  • Question

  • Hi ALL,

    Getting the following error while converting from Oracle 11.2 to Azure SQL Database through SSMA 8.4 for a Oracle function.

    Warnings: O2SS0452: "xp_ora2ms_exec2_ex" when called from within UDF cannot bind to outer transaction. It can lead to dead locks and losing transaction atomicity. Consider calling $impl procedure directly.
     Errors: O2SS0518: Wrapper functions are not supported by Azure SQL platform. Use $impl procedures instead.

    While testing the migrated function in Azure.. the call to the XXXX$impl function does not go and return value is 0. 

    Please help!



    Friday, September 27, 2019 6:39 PM

All replies