A stored procedure is a subprogram that is stored in the database as a PCODE and thus called as a standalone schema object.
a) It can be invoked directly from any calling environments, or other subprograms.
b) It is similar to any subprogram that accepts parameters and performs an action. It may or may not return a value. This attribute differentiates it from another subprogram type called FUNCTION.
c) It can be nested
d) Is created by using the syntax CREATE OR REPLACE
e) This stored procedure can be seen as an object in the User_Objects and is different from the procedures that are created in packages.
No comments:
Post a Comment