Entity Framework Core Stored Procedure Return Value


Return Values in SQL Stored Procedure Example 1. [code]create procedure dbo. To test it, I used a very simple piece of code. Microsoft's Entity Framework is an extended ORM that helps you to isolate the object model of your application from the data model. This scenario is commonly used to reduce the number of database round trips required to compose a single screen. If a join statement is used on two different tables, then need to write an internal class for the returned values of sql statement. Entity Framework is an Object / Relational Mapper (O/RM) that helps you read and write data from and to a database. After a short introduction, he examines the creation of the stored procedures and Web Forms, addition of the Stored Procedures to the Entity Model including adding. These stored procedures might be doing some custom processing and there are at least four distinct types of values. That's all there is to using stored procedures with Dapper. Although we like Entity Framework Core, there are occasions when the appropriate tool to work with the logic of data access in our application is ADO. Add Entity Framework Core to the ASP. Introducing the ADO. With Entity Framework in ASP. Add Entity Framework Core to the ASP. In the post I’m going to explain how to map results of a stored procedure to a custom created entity which we have created with the Entity Framework designer. Dapper is sometimes described as an ORM, but as we’ll see it’s more of an “object mapper”. However, this is no longer available in Entity Framework Core. By Peter Vogel; 05/30/2014. NET, so in that case we need to. com: using-stored-procedures-entity-framework-scalar-return-values. Entity Framework is an Object / Relational Mapper (O/RM) that helps you read and write data from and to a database. EF also allows you call arbitrary stored procedures from your code. Basically I want to get multiple result set from a single stored procedure. Instead, I’d suggest you make use of Dapper, which does support mapping arbitrary data to objects. These stored procedures might be doing some custom processing and there are at least four distinct types of values. Get return value from stored procedure using ExecuteSqlCommand (using Entity Framework) 2 Getting stored procedure output parameter with Entity Framework is throwing a mapping error: The data reader is incompatible with the specified. net-core c# entity-framework entity-framework-core. In those very rare cases, it may make sense to return more than one result set from a stored procedure. Entity Framework Core - Getting Started. Stored procedures should use output parameters or result sets to return data, and use errors to indicate success or failure. If an Entity Framework function mapped to a stored procedure is to have a return value other than null, the value must be provided by the Oracle stored procedure as an OUT parameter of the type SYS_REFCURSOR. 1 was released store functions (i. Execute stored procedures with Entity Framework Core. But client stored procedure return values should not be used from client code. It was released along with. It eliminates the need for most of the data-access code that developers usually need to write. NET Core application and connect it to a database and perform CRUD actions using Entity Framework 3. Define the returned data type in your models and context. On this article I will explain one of them : Scalar function mapping At last! we can use SQL SERVER's Scalar Function in LINQ to Entities!. Entity Framework Core (or EF Core) is the latest version of Entity Framework and is a complete rewrite. net connectivity with complete pictorial guide and step by step examples. Net Framework. Stored procedures (SP) makes life easy of coder. Get the source code from the GitHub repository. In this article, i will explain how to create custom repositories in ASP. But unlike FromSql() method, it returns the number of affected rows. Entity Framework 4 in Action is an example-rich tutorial for. In this example, we will show you the default return value returned by the SQL Server. In a nutshell, DbContext, DbSet, and DbQuery are the classes that have encapsulated the most frequently. The stored procedure used for the scenario is a stored procedure that retrieves a single recipe with the ingredients that are part of the recipe. It has been designed to be lightweight, extensible and to support cross platform development as part of Microsoft's. April 15, 2018 April 15, 2018 /. NET MVC In the Add Function Import screen please give the function name as you need and select the return type of that stored procedure based on your requirement. NET MVC: Use Entity Framework to return multiple result sets from a Generic Repository If you have a simple generic repository, it doesn't make sense to put everything into one repository. This scenario is commonly used to reduce the number of database round trips required to compose a single screen. I think there has to be some way to call the stored procedure with using Entity and then map it to any class because select columns from multiple tables using join is a very basic requirement. Although we like Entity Framework Core, there are occasions when the appropriate tool to work with the logic of data access in our application is ADO. Stored procedures allow us to encapsulate operations that we will perform in a database. However, there is no simple way to create views, stored procedures, functions, bulk seed data, and post deployment scripts as part of the migrations. SEQUENCE was introduced in SQL Server 2012. This article presents a discussion on how we can work with raw SQL queries in Entity Framework Core. Understand how they differ in architecture, supported databases, configuration and mappings, table inheritance, collections, primary keys generation, tooling and much more in this comprehensive guide. I believe the reason is, it is not a good practice. How to call stored procedure using repository pattern and unit of work The stored procedure approach in entity framework is not advisable as it makes mocking of repository difficult. Select the required stored procedure in the list of the stored procedure to edit its parameters. \$\begingroup\$ @YuriyN. The second edition of this acclaimed guide provides a hands-on tour of the framework latest version in Visual Studio 2010 and. Hello, an ordinal way to execute stored procedure in EF CF is something like this: public Product GetProduct(int id) { Product produc. Contents for. Execute Stored Procedure using Entity Framework in ASP. They were creating an ASP. Scalars Scalars means stored procedure will return single value of selected type like. So, first-of-all, we will add a model class in our project and create a database using migrations and then we will create stored procedures for insert, update and delete using Fluent API. It sounds like you have a SQL Server database that was migrated from some. Entity–attribute–value model (EAV) is a data model to encode, in a space-efficient manner, entities where the number of attributes (properties, parameters) that can be used to describe them is potentially vast, but the number that will actually apply to a given entity is relatively modest. How to execute stored procedure and get return result in MVC/EF/LINQ. So my question is how to select columns from multiple tables in the stored procedure in Entity Framework Core. If a join statement is used on two different tables, then need to write an internal class for the returned values of sql statement. Overview of Entity Framework. This is useful when for some reason we can not or do not want to use Entity Framework Core. NET data providers in June, 2002, DataDirect Technologies has been fully committed to boosting operational performance in real-world environments such as Microsoft SQL Server. Stored procedure execution was not supported in entity framework core: Raw store access APIs: Support for ad hoc mapping of arbitrary types #1862; Stored procedure mapping support #245; It is now supported since EF Core 2. After that, I’ll show you how you can mimic wildcard searches. Accessing Stored Procedures with Connector/NET. Stored Procedure Returning Result Set using REF CURSOR Out Parameter It is not applicable to Entity Framework Core, which does not support stored routines. to gain the benefits of EF with a legacy database, there are various ways to harness this capability in Entity Framework. What I can see from your code is that's a little difference. In that query, Entity Framework was selecting both the teams in a given sport and the players involved with each team (via an Include() statement), whereas the ADO. Whether you're new to Entity Framework, or been using it for a while but are looking for a. Correct should as below: CREATE PROCEDURE GetMyInt1 ( @SellId int ,@OutValue int OUTPUT) AS BEGIN SELECT @OutValue=TotalAmount FROM Sells WHERE SellId = @SellId select @OutValue END. Oracle pipelined functions are stored functions that return a collection type result iteratively by elements. How to execute stored procedure and get return result in MVC/EF/LINQ for status codes only and it can return INT values Stored Procedures in the Entity Framework. I need to read the return value from a stored procedure; I am already reading output parameters and sending input parameters, but I don't know how to read the return value. Net Framework. For the current version of EF Core, there isn't support for stored procedures, so we can't use them in a native way, inside of DbSet, there is a method to execute a query but that works for stored procedures not return a result set (columns), we can add some extension methods and add packages to use classic ADO. Execute Stored Procedure using ExecuteSqlCommand() The ExecuteSqlCommand() is another method to execute Stored Procedures and Raw SQL in Entity Framework Core. In Part 1 of this two part series, you learned to map stored procedures for the INSERT, UPDATE and DELETE operations in the entity framework designer. A ref cursor can be returned as an OUT or IN OUT parameter. Write procedure in SQL Server Management Studio under your database. NET Forums / Data Access / ADO. 0; Understanding Dependency Injection in ASP. ExecuteFunction is not working. What I can see from your code is that's a little difference. c# - timeouts - entity framework timeout stored procedure Entity Framework Timeouts (5) I am getting timeouts using the Entity Framework (EF) when using a function import that takes over 30 seconds to complete. Entity Framework has always had a mixed reputation, with some developers loving it while other compared it unfavorably to NHiberante, LINQ-to-SQL, and the various micro-ORMs. NET Core and is an extensible, lightweight and cross-platform version of Entity Framework. Programming Entity Framework, 2nd Edition. sp going to return three. When we execute this stored procedure, after inserting the record, it returns the PersonalDetialsId value of last inserted record. As performance becomes more important, it does, however, require some knowledge of the traps that you need to avoid, and of the wrinkles that impact performance. You will see how to create a MySqlCommand object. Пусть наша база данных, как и в прошлой теме, описывается следующим контекстом данных и моделями:. Prior to Entity Framework 5. Their mappings are defined through JDK 5. Table Valued Functions and Stored Procedures) could be used in EF only when doing Database First. The Manage Stored Procedures dialog will be invoked. It all depends on the volume, where, how long and how do you want to query actions performed against the data. Entity Framework 6. 0 - Table Valued Functions and LINQ Composition 31 July 2016 Comments Posted in Entity Framework, OSS,. I think there has to be some way to call the stored procedure with using Entity and then map it to any class because select columns from multiple tables using join is a very basic requirement. net core and EF core in my application. Using these asynchronous methods along with the async/await pattern you can query the database asynchronously. How to call stored procedure using repository pattern and unit of work The stored procedure approach in entity framework is not advisable as it makes mocking of repository difficult. EF Core – Combining SQL and NoSQL for better performance. [GetUsernames] AS BEGIN SET NOCOUNT ON; SELECT UserName FROM AbpUsers END GO Now we implemented the functon that calls stored procedure from database. return catList;. Tom { // Working code commented out below. Action Stored Procedure calls. credit ratings do not address any other risk, including but not limited to: liquidity risk, market value risk, or price volatility. We are still running commands in database context but what we are doing is not monitored by Entity Framework core. I can get output values, I can get result sets, but no return value. Building generic repository. Sometimes, however, you want to use stored procedures, returning to write in SQL. NET, like some sort of peasant from 2003. In Part 1 of this two part series, you learned to map stored procedures for the INSERT, UPDATE and DELETE operations in the entity framework designer. Entity Framework Core and calling a stored procedure. This is also possible using the mapping of Entity Framework, and it makes calling a stored procedure as simple as invoking a method. Your problem is this: you're returning the value from the stored procedure (using RETURN @paramter2), but your. By Peter Vogel; 04/29/2014. You can read it Database connection string in Entity Framework. The way the connection string is specified has changed from the previous version of the entity framework. Return Values in SQL Stored Procedure Example 1. Add Entity Framework Core to the ASP. It eliminates the need for most of the data-access code that developers usually need to write. NET Core and more specifically Entity Framework Core. This article helps the developers who works on Entity Framework how to get the output parameter values from stored procedures using Entity Framework in various scenarios like last inserted or updated record ID. Tried to search it for last 2 days no such luck. How to execute a Stored Procedure with Entity Framework Code First. So the obvious question is what's the difference and when to use one over the other. Tracing data changes can be beneficial in narrowing down the issue that may occur in production. dbml file, Visual Studio will fail to work out the return type to use. As an alternative to Entity Framework Core you could use a hybrid approach by using Dapper. NET, so in that case we need to. To edit stored procedure parameters, select the Entity Framework data source in the Report Explorer and click the ellipsis for its EFDataSource. One of the most used approach is to use an SqlCommand object of type. In my mind, EF Core generates queries for the underlying data provider which. Raw SQL Queries. Ever since the beginning of last year, I've been following the development of. Add Entity Framework Core to the ASP. NET Core |. The following is a sample TVF GetCourseListByStudentID in SQL Server database, which will return all the courses of a particular student. NET code to manipulate database data. Length values are in bytes for nonbinary and binary string. NET supports function import of Oracle stored procedures that Entity Framework can then execute. Enough talk. net core and EF core in my application. The above issue is the reason why I feel this article is necessary. NET Core Full Stack training, my client asked me to explain the mechanism of accessing SQL Server Stored Procedures using Entity Framework (EF) Core. One deficiency with Entity Framework is the ability to load data from a stored procedure or a direct query when the column names don't match your model property names exactly. These Oracle function imports can return a collection of scalar, complex, and entity types, including returning an Oracle implicit result set as an entity type. Even in a Code First environment, you can call a stored procedure from a DbContext object. net core App. NET supports function import of Oracle stored procedures that Entity Framework can then execute. so the stored procedure could return an instance of this Product class. For SDE it also creates “sequence” tables for the registered tables which shows up as [SCHEMA]. For the ADO. I wrote a post some time back about calling a stored procedure with Entity Framework using the DbCommand, but it was a bit complicated and not that easy to use. Once a MySqlCommand object has been created, you will call one of the previous methods on it to carry out a database operation, such as perform a query. Their mappings are defined through JDK 5. Raw SQL queries are also used if using a LINQ query is resulting in an inefficient SQL query. For every call mapped, the designer will generate in the generated context class a method, with the name: CallStoredProcedureName. This section guides you through the step by step procedure on how to create a basic web application for the CRUD operations using Entity Framework Core and Asp. It brought new features. [code]create procedure dbo. In this post, I am going to explain CRUD using Blazor and Entity Framework Core. Topic Overview Purpose This topic demonstrates how to bind an Infragistics report to an Entity Framework Data Model using a stored procedure. Stored procedure in Entity Framework is called a function. NET Forums / Data Access / ADO. A small descriptions is given bellow. It's something in the database, which sadly, is the part you have not given us any details about, not even which RDBMS it is. NET Core application in the Startup class. The stored procedure used for the scenario is a stored procedure that retrieves a single recipe with the ingredients that are part of the recipe. So the obvious question is what's the difference and when to use one over the other. The support for stored procedure in EF Core is similar to the earlier versions of EF Code first. We can even invoke stored procedure to return scalar/non scalar results through command objects on "DBContext. This post is for those who had some experience with Linux or had tried Linux before, but never made up mind to […]. posted on March 22, 2016 by long2know in ASP. Code Examples - Microsoft SQL Server Overview Since the release of our first ADO. [code]create procedure dbo. net connectivity with complete pictorial guide and step by step examples. How to Create an Entity Framework Data Model Using Stored Procedures. Map Stored Procedures to Custom. In EF 6, we used to have SqlQuery to do both actions in one command, how can I do the same in EF core ? UPDATED: Temporarily, I run 2 query, one to get the output param and one for result set. Entity Framework 7. Overview of Entity Framework. The above issue is the reason why I feel this article is necessary. We have successfully created an ASP. Net MVC 5 Razor. Entity Framework 4 in Action is an example-rich tutorial for. It was released along with. If an Entity Framework function mapped to a stored procedure is to have a return value other than null, the value must be provided by the Oracle stored procedure as an OUT parameter of the type SYS_REFCURSOR. One of the biggest (and few) drawbacks to CodeFirst is that it doesn’t support calls to stored procedures. , a scalar value). StoredProcedures property in the Properties window. Now, I understand that stored procedures are messy beasts. There are two ways to run Oracle pipelined function via Entity Framework - creating an entity based on such function or reting a Function Import. changes in SQL queries have minor effects in C# code which can be understood and solve very easily. , control structures, loop, and complex calculation to extend SQL-standard. This blog provides the procedure to create an ASP. NET code to manipulate database data. Tried to search it for last 2 days no such luck. How to execute Stored Procedure in EF Core. The RTM version of EF Core should be available very soon (end June 2016) but will only include support for calling stored procedures that return entities. Entity Framework core gespeicherte Prozedur Arbeite ich mit dem EF-Core (code-first), und die wollen zu greifen, die Daten aus einer gespeicherten Prozedur. At times, however, you may want to deviate from this default behavior and use stored procedures for these operations. Stored Procedure Returning Result Set using REF CURSOR Out Parameter It is not applicable to Entity Framework Core, which does not support stored routines. Contents for. 1 Store Functions TVFs TVF table valued functions stored procedure sprocs stored proc scalar functions UDF UDFs user defined functions Code First CodeFirst moozzyk blog. the code for one of the stored procedures. Net MVC without using Entity Framework. [ Microsoft. Map Stored Procedures to Custom. Net Framework. Here is the store procedure that is called: USE [PhoneBookDb] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo]. When that situation comes up, Dapper is my tool of choice. In addition, returning types of stored procedures are usually more complex than the simple entity types. You can use Entity Framework to map your stored procedures, or you can call them manually. NET Framework 4. a Full Text Search), if the generated SQL is not efficient enough, if you want to make use of existing stored procedures, or if you just prefer to write your own queries in SQL. Pay attention that this stored procedure is simple and it's only to show how to perform the mapping to a custom entity. The return value can be accessed from code (C# for example), like this: SqlParameter Unit Testing With. Table-Valued Function in Entity Framework. Entity–attribute–value model (EAV) is a data model to encode, in a space-efficient manner, entities where the number of attributes (properties, parameters) that can be used to describe them is potentially vast, but the number that will actually apply to a given entity is relatively modest. In this section, we are going to cover Migrations and Seed data features in Entity Framework Core. This feature is available in Entity Framework Core as well. What I want to do in this blog post is show you how you can use the “raw” data access mechanisms (ADO. we used stored procedures along with custom classes for database transactions. NET Framework. In Part 1 of this two part series, you learned to map stored procedures for the INSERT, UPDATE and DELETE operations in the entity framework designer. [GetUsernames] AS BEGIN SET NOCOUNT ON; SELECT UserName FROM AbpUsers END GO Now we implemented the functon that calls stored procedure from database. net core and EF core in my application. Using these asynchronous methods along with the async/await pattern you can query the database asynchronously. The Entity Framework allows you to use stored procedures in the Entity Data Model instead of, or in combination with, its automatic command generation. In this article we are going to learn about Queries in Entity Framework Core and different ways to use them to fetch out data from the database. To test it, I used a very simple piece of code. In this blog, I am going to provide a walk-through on developing a web application using ASP. Stored Procedures in the Entity Framework. Net Framework. Map CRUD Stored Procedures to Entities with Entity Framework By Christos S. Recently I worked on a project, which I started as code first and then I forced to switch to Database first. I pushed quite hard for the past two weeks and here it is - the beta version of the convention that enables using store functions (i. i3_get_ids and sde. Add Entity Framework Core to the ASP. And follow these below steps: Step-1: Create Tables Create first Table. Missing Features in Entity Framework Core Updated: with EF Core 1. Posted by Anuraj on Wednesday, July 20, 2016 Reading time :2 minutes. Stored Procedure Returning Result Set using REF CURSOR Out Parameter It is not applicable to Entity Framework Core, which does not support stored routines. You can omit creating an entity if you want to as you can directly map the response to an object or dynamic but it helps to. The one thing missing was the ability to return multiple result sets. In this article we are going to learn about Queries in Entity Framework Core and different ways to use them to fetch out data from the database. How to invoke a stored procedure in Web API using Entity Framework In this tutorial, we will go over sample code to retrieve data with Web API and Entity Framework (invoking a stored procedure to return data). It took 15 minutes to write and run stored procedure with parameters. Populating Entity Framework Models with SqlDataReader. SEQUENCE was introduced in SQL Server 2012. The results are usually returned into a MySqlDataReader object, and then processed, for example the results might be displayed. 1 web application but this works just as well with console applications. The information about your database structure (store schema), your data model (conceptual model) and the mapping between them is stored in XML in an. After it has been created, there are three main methods of interest that you can call: Finally, you will see how the ExecuteScalar method can be used to return a single value. It is similar to Identity column, but there are many differences between them. Add Entity Framework Core to the ASP. • Here, the ef core will generate a sql ordered by decending and select the top. In this tutorial, we are going to cover crud operations (create, read, update, and delete) using entity framework core & stored procedure with Fluent API. SQL Server doesn't allow composing over stored procedure calls, so any attempt to apply additional query operators to such a call will result in invalid SQL. Entity Framework Net Core 2. Is Entity Framework Core slower than using ADO. The code listings and log output in this post came from an ASP. NET developers to work with relational data using domain-specific objects. Estoy usando Entity Framework 5 con el enfoque Code First. To begin with, a little info about Sequence. When you map in the designer a Stored Procedure Call to a stored procedure which doesn't return a resultset, it's considered a call to an action procedure. NET Core framework, which is intended for cross-platform development. Using the Find() method • The Find method will return an object by taking in the primary key of the entity. see moody's rating symbols and definitions publication for information on the types of contractual financial obligations addressed by moody's investors service credit ratings. [code]create procedure dbo. Step 1 − Select the Console Application from the. 0 - Table Valued Functions and LINQ Composition 31 July 2016 Comments Posted in Entity Framework, OSS,. 5 Framework SP1, SQL Server 2008) I imported this stored procedure into the framework diagram and then made it a function import. Table Valued Functions and Stored Procedures) could be used in EF only when doing Database First. The stored procedure being called returned a lot of data and writing the mapping code manually could lead to maintenance headaches down the road if the fields changed. LINQ is a powerful tool that lets you skip the database stored procedures and coding and pull data directly from your entities. 0 - Table Valued Functions and LINQ Composition 31 July 2016 Comments Posted in Entity Framework, OSS,. 0 command, and performing CRUD operations using scaffolding (code generator). These Oracle function imports can return a collection of scalar, complex, and entity types, including returning an Oracle implicit result set as an entity type. However, I found that optional parameters must be handled properly. Get a thorough introduction to ADO. Dapper is sometimes described as an ORM, but as we’ll see it’s more of an “object mapper”. To edit stored procedure parameters, select the Entity Framework data source in the Report Explorer and click the ellipsis for its EFDataSource. NET developers to work with relational data using domain-specific objects. Here's a handy extension method you can use to make it easier. We will call the stored procedures by using classes and methods generated by Entity Framework. c# - timeouts - entity framework timeout stored procedure Entity Framework Timeouts (5) I am getting timeouts using the Entity Framework (EF) when using a function import that takes over 30 seconds to complete. The '128 patent includes operations to register and attach the UE to the core network and to encrypt and protect traffic between the UE and core network entities. The database table where the information will be inserted is the Student table. The RTM version of EF Core should be available very soon (end June 2016) but will only include support for calling stored procedures that return entities. See the EF Core roadmap : Raw SQL queries for non-Model types allows a raw SQL query to be used to populate types that are not part of the model (typically for denormalized view-model data). You can read it Database connection string in Entity Framework. LINQ is a powerful tool that lets you skip the database stored procedures and coding and pull data directly from your entities. It was released along with. In this return value example, we will show how to use return values in Stored procedures. Dec 02, 2015 at 3:19PM I'm having problems trying to access a stored procedure in EF 7. in this video tutorial, I demonstrate that how we can use stored procedures in entity framework and asp. V1 of the Entity Framework allows you to use stored procedures in two main ways: Mapping Create, Update and Delete entity operations to appropriate stored procedures. After a short introduction, he examines the creation of the stored procedures and Web Forms, addition of the Stored Procedures to the Entity Model including adding. NET Core with Entity Framework Core: Returning Multiple Result Sets. Doing a FunctionImport that allows you to return an enumeration of Entities* Now the thing is, in order to return an enumeration of Entities, you have to map the Entity. NET Framework. Last week while conducting a. Net CORE - Call stored procedures and Queries. a Full Text Search), if the generated SQL is not efficient enough, if you want to make use of existing stored procedures, or if you just prefer to write your own queries in SQL. Understand how they differ in architecture, supported databases, configuration and mappings, table inheritance, collections, primary keys generation, tooling and much more in this comprehensive guide. Entity Framework SqlQuery for Stored Procs. This is a simplified version of what I've got:. The way the connection string is specified has changed from the previous version of the entity framework. NET Core Full Stack training, my client asked me to explain the mechanism of accessing SQL Server Stored Procedures using Entity Framework (EF) Core. Net Core: hence the method would return 1 on success. It brought new features. I think there has to be some way to call the stored procedure with using Entity and then map it to any class because select columns from multiple tables using join is a very basic requirement. NEW IN 2019 – “Building a robust CQRS database with EF Core and Cosmos DB“. Display Data using a Stored Procedure in an ASP. What I can see from your code is that's a little difference. One of the most used approach is to use an SqlCommand object of type. [code]create procedure dbo. 1 which is in Release Candidate since 7 may 2018. You can omit creating an entity if you want to as you can directly map the response to an object or dynamic but it helps to. Importing Stored Procedures that Return Scalar Values. So for stored procedures involving scalar values, the EF expects them to return a collection of scalar values rather than just one. In this article, we've looked at how to use Entity Framework and stored procedures in a variety of ways. However, if you want to do so, e. 34 th Friday Fun Session (Part 1) - 22 nd Sep 2017. If you want to learn how to use Entity Framework for database operations in ASP. If an Entity Framework function mapped to a stored procedure is to have a return value other than null, the value must be provided by the Oracle stored procedure as an OUT parameter of the type SYS_REFCURSOR.