Result Set Stored Procedure. ORACLE supports Oracle Database - Stored Procedure which returns SQL Engine - Result Set. In Microsoft SQL server I could do something like this.
A stored procedure is a named set of PLSQL statements designed to perform an action. They define a programming interface for the database rather than allowing the client application to interact with database objects directly. Prior to EF5 Entity Framework would allow the stored procedure to be called but would only return the first result set to the calling code.
Active 4 years 1 month ago.
Active 4 years 1 month ago. Introduction to PLSQL Stored Procedures. SELECT the rows specified by the SELECT statement will be sent directly to the client. ORACLE supports Oracle Database - Stored Procedure which returns SQL Engine - Result Set.