Forms - Creating Database procedures and functions in forms.
Forms supports to create objects procedure, function, package specification and package body.
These objects are permanently stored in the database.
Example
Open the form builder tool
In the Object Navigator, Select Database Objects SCOTT PL/SQL stored program units
Click on create button
Name -- Display
Types -- procedure
Click on OK
Provide the following code
Create or replace procedure display
is
begin
dbms_output.put_line ('Hello Learners.... Have a nice time....');
end;
Click on Close
You get the following window.
Click on Apply.
We can see the display procedure under PL/SQL stored program units.
Now, we can execute the same procedure in our SQL*plus environment
So, we can create database objects like procedures, functions, packages from form builder tool.