This is documented: User-Defined Functions and Stored Procedures, "Functions That Require a Connection". It's a problematic feature because the Oracle JDBC driver will try to resolve this database URL if it is loaded before the H2 driver.
So basically you can't use the feature if the Oracle driver is loaded (I consider this a bug in the Oracle driver).
You can use stored procedures either to get the data or to add/update/delete the records for one or multiple database tables.
EF API creates a function instead of an entity in EDM for each stored procedure and User-Defined Function (UDF) in the target database.
If you are writing from -- remote server to local drive, please use UNC path and make sure server has -- write access to your network share exec @rc = sp_trace_create @Trace ID output, 2, N'c:\My Folder\My Trace\SP_usage', @maxfilesize, NULL if (@rc !Starting with SQL Server 2008 Microsoft introduced Extended Events that will replace Profiler and server side traces.Keep in mind that both of these will be deprecated in future versions of the SQL Server.Using a query similar to the one that we used in the SQL Server Agent Job above, we can create a Custom Collection Set that uses the generic T-SQL Query Collector type.The advantage of this method is that you do not lose procedure execution history when this collector is in cache mode.