Discussion Board

Standalone subprogram The above statement is wrong. A PL/SQL subprogram is a named PL/SQL block that can be invoked repeatedly. If the subprogram has parameters, their values can differ for each invocation. A subprogram is either a procedure or a function. Typically, you use a procedure to perform an action and a function to compute and return a value. A subprogram created at schema level is a standalone subprogram. You create it with the CREATE PROCEDURE or CREATE FUNCTION statement. It is stored in the database until you drop it with the DROP PROCEDURE or DROP FUNCTION statement. Prajakta Pandit 02-14-2017 02:17 AM

Write your comments

*

* Email must be in the form someone@domain.com

*

*