ASP.NET Core 5 WebAPI Oracle Data Insertion using Stored Procedure | HTTP Method|Microservices|Day7
I have explained what is stored procedure in oracle and what are the advantages of using it over the inline query. how can we write procedure for inserting the data in oracle database. how can we connect stored procedure for HTTP post method using ADO.Net to insert the data in oracle database.
What to learn:
1. Oracle TNS Listener issue.
2. What is stored procedure and implementation of stored procedure in oracle.
3. Connecting Stored procedure with HTTP Post action method to insert the data.
4. Creating request and response for HTTP post action method.