-
Copyrights 2010 - Online Training Oracle Applications. All Rights Reserved.
|
Create table student using the following query at SQL*Plus environment. SQL> create table student ( roll number(3), Create package specification using the following code create or replace package mypak
type stutab is table of srec index by binary_integer; procedure stuqry ( data in out stutab); end mypak; Create package body using the following code create or replace package body mypak procedure stuqry ( data in out stutab) open scur; procedure stuins ( data in stutab) end mypak; Open the form builder tool Procedure -- mypak.stuqry Refresh Move all the columns from available columns to Database Items Next Enter procedure to insert data for your data block Next Enter procedure to update data for your data block ( As we have not created procedure to update, leave it blank ) Next Enter procedure to delete data for your data block ( As we have not created procedure to delete, leave it blank ) Next Enter procedure to lock data for your data block ( As we have not created procedure to lock, leave it blank ) Next Data Block Name -- Student Next Finish Now, we will get Layout wizard, complete the layout wizard. File Save as STUDENT.FMB Enter the following details and save. Stuid -- 1 We get the confirmation message as "Transaction Completed" Now, we can see the record at our SQL*Plus environment. Insert multiple records and check the execute query functionality.
Advantage We can have custom code for data manipulations and retrieval purpose rather than depending on system defined code given by forms.
|