Email Us : sunilkumark11@gmail.com
Free Training > SQL PL / SQL Forms Reports Oracle Applications
< Previous Next >

 
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.

 


< Previous Next >