A script-enabled browser is required for this page to function properly.

About Resolving Subprogram Names

When a form is compiled, the PL/SQL compiler may encounter the name of an identifier that could be a procedure or function. The PL/SQL complier users a precedence mechanism to resolve ambiguities.

If an identifier such as PROCNAME is encountered that has the structure of a procedure or function, the compiler will use the first match found in the following search order:

  1. Is it defined within the current PL/SQL block?
  2. Is it a standard PL/SQL command?
  3. Is it an Oracle Forms Built-in subprogram procedure or function?
  4. Is it a user-named procedure or function?
  5. Is it defined in package DBMS_STANDARD on the serverside?
  6. Does the current user have access to any such procedure or function on the server side?

If the answer is "no" to all of the above, then the compiler signals an error:

PL/SQL error 313 at line xxx, column yyy
'PROCNAME' not declared in this scope
or
PL/SQL error 201 at line xxx, column yyy
identifier 'FUNCTNAME' must be declared.


About Stored Programs

Creating a Stored Program