You can create, edit, compile, and browse stored procedures directly from Oracle Forms if you have the appropriate privileges.
Execute Privilege |
Allows the user to execute the public subprogram defined in a Stored Program unit. Public subprograms are Listed in the package specification. |
Create Privilege |
Allows the user to create, modify, and compile Stored Program units. |
Compile Privilege |
Allows the user to compile a Stored Program unit. |
Drop Privilege |
Allows the user to drop a Stored Program unit. |