InterviewSolution
| 1. |
What Are Stand-alone Procedures? |
|
Answer» 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. 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. |
|