Your organization wants to use the “managers_pkg” package that you created to insert, delete, update, lock, and count a record.

You have been assigned to develop an application form to manipulate the managers table using transactional triggers.

-- Hands-on 13 (Form Block and Transactional Triggers using Developer v6i tool)

Click on the "+" sign next to "Database objects" to expand it.

Expand the ISELF schema.

Then, expand the "Stored Program Units" item.

Open the "Managers" package body.

Browse through the package body that had been created during the previous hands-on exercise.
We are going to use these delete, update, and insert procedures to manipulate the "FORM BLOCK" object.


Close "WINDOWS." 

Browse through the package specification and then close the window.

Change the "FORM" name to "MANAGERS_INFORMATION."

Highligh or select the "Data Blocks" item, and then click on the "Create" icon.

Use the Data Block Wizard to create a new Data Block.

Click the "NEXT" button to continue.

Click "NEXT" again.

Click on the "Browse" button and select the "MANAGERS" table.

Then, click "OK."

Select all items and click "NEXT."

Select the "Just Create the data block" option and click "FINISH."

Now, open the "MANAGERS" data block's property palette.

Change the "Query Data Source Type" item to "procedure,"

the "Source Name" item to "MANAGERS_PKG.MANAGERS_REFCUR."

On "Source Columns," you do not need to set anything in its property, as Forms has already done this since you began by creating the block with a data block as a Table. 

Close it.

On "Source Arguments," type "MANAGERS_DATA."

Set the Type to "REFCURSOR."

Set "Type Name" to "MANAGERS_PKG.C_MANAGERS."

set the "Mode" to "IN OUT."

Close the window.

Change the "DML Data Target Type" item to "Transactional Triggers."

Close the window.

Highlight "Triggers" and click on the "Create" icon.

Type the letter "O," then "I" and click "OK."

Write a stored procedure to insert a record into the "MANAGERS" table.

Notice that the "MANAGERS_INSERT" procedure was created during the previous Hands-On.

Compile the trigger.

Let's copy the code so we can use it to create other triggers.

Click on "New" and type the letter "O" and "L."

Click on "OK."

Write a stored procedure to lock a record. 
Use "MANAGERS_LOCK" that was created from the previous Hands-On.

Compile the trigger.

Click on "New" and type the letter "O" and "U." Then click "OK."

Write a stored procedure to update a record.
Use the "UPDATE" procedure from your created package.

Compile then trigger, then click on "New" and type the letter "O" and "D."

Click "OK."

Write a stored procedure to delete a record.
Use the "Delete" procedure from your create package.

Compile it then click on "New" and type a letter "O" and "C."
Click "ON-COUNT" and then click "OK."

Write a stored procedure to count the "MANAGERS" records.
Then set the block property to refresh the number of records.

Compile the trigger and close the window.

Go to the "Tools" menu and select the "Layout Wizard" option.

Click on "next" to continue.

Use the default canvas type.

Select all items and then click on the "Next" button.

Change the prompt if it is needed.

Use the "Form" option.

Change title to "Managers Name" and click "Next."

Click on the "Finish" button.

On the layout FORM, run the program to test it.

Insert records into the Managers table.

Save the inserts. Two records were added.

Update a record and navigate through your changes.
The record was changed.

Save the update. 

Delete record and test the delete action.

Close the application and save the FORM.


Now, you should practice this over and over, until you become a master at it.

Good Luck!