top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What are stand-alone procedures ?

+5 votes
397 views
What are stand-alone procedures ?
posted Feb 1, 2014 by Anuj Yadav

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Procedures that are not part of a package are known as stand-alone because they independently defined. A good example of a stand-alone procedure is one written in a SQL*Forms application. These types of procedures are not available for reference from other Oracle tools. Another limitation of stand-alone procedures is that they are compiled at run time, which slows execution.

answer Feb 2, 2014 by Vikas Upadhyay
...