Forward Declaration

{\rtf1\ansi\ansicpg1252\deff0\deflang16393{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\fnil\fprq2\fcharset2 Wingdings;}{\f2\fnil\fcharset0 Calibri;}}
{\*\generator Msftedit 5.41.21.2509;}\viewkind4\uc1\pard\lang1033\f0\fs22\par
\pard\li1080 P/L SQL does not allow forward declaration. Identifier must be declared before using it. Therefore, subprogram must be declared before calling it. PL/SQL requires that every identifier must be declared before use. There are occasions where such declaration is not possible. For instance, 2 mutually recursive procedures will need to refer to each other before anyone such procedure can be declared. The solution is by Forward Declaration in which function or procedure's specifications are declared at the declaration. Another way to do forward declaration is to set up a package, which can be separated into specification part and body part.\par
Forward Declaration can be used to do the following:\par
\pard\li1080\tx2160\f1\'d8\tab\f0 Define Subprograms in logical or alphabetical order.\par
\pard\li1080\f1\'d8\tab\f0 Define mutually recursive subprograms.\par
\f1\'d8\tab\f0 Group subprograms in a package.\par
\pard\li720\par
\pard\sa200\sl276\slmult1\lang9\f2\par
}