Question: Urgent ! Using employees table. Write a procedure that will accept ID and name of an employee from the calling environment, the procedure should insert

Urgent!

Using employees table. Write a procedure that will accept ID and name of an employee from the calling environment, the procedure should insert the new employee, If the employee inserted successfully, the procedure should send 0 to the calling environment, otherwise it should send 1.

Handle exceptions if any errors occurred. Hint: (Dup_val_on_index).

Your answer should include the procedure block and the anonymous block.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Employees (employee_id, first_name, salary) Using employees table. Write a function that will accept ID and name of an employee from the calling environment, the function should insert the new...

( Employees (employee_id, first_name, salary) Using employees table. Write a function that will accept ID and name of an employee from the calling environment, the function should insert the new...

plsql ( Employees (employee_id, first_name, salary) Using employees table. Write a function that will accept ID and name of an employee from the calling environment, the function should insert the...

In T-SQL Please. I would really appreciate it! Please fulfill the requirements stated below with the following database: /*use master; GO Alter database Project3 set single_user with rollback...

UMUC Haircuts Appointment Process Individual Needs Appointment for Hair Styling Calls UMUC Haircuts and requests appointment Drives to UMUC Haircuts 1 Employee greets customer and asks customer last...

Case requirements 1.Imagine yourself in Nancy John's position. Recall that Nancy was openly critical of the previous Executive Director (ED). Using the fraud triangle as a guide, speculate on the...

Publication 15 In this step, you will use the Wage Bracket Method to calculate withholding. In this method, you do not need to calculate withholding allowances, but there are fairly-low limits as to...

Please help me make an Executive Summary. Explain what you will examine in the case study. Write an overview of the field you are researching. Make a thesis statement and sum up the results of your...

Publication 15 Withholding for Federal Income Tax can be calculated using one of two methods. The first, covered in this section of the exercise, is the Percentage Method. Everett Kelly is married...

Assignment 2 (Due is April 20 th ) Question 1 Identifying Customers Assignment 2 (Due is April 20th) Question 1 Identifying Customers Brewbeans Coffee Company wants to offer an incentive of free...

Sharon Feldman, president of Allied Company, considers $20,000 to be a minimum cash balance for operating purposes. As can be seen from the following statements, only $15,000 in cash was available at...

Determine the x, y, z components of internal loading at a section passing through point C in the pipe assembly. Neglect the weight of the pipe. Take F 1 = {-80i + 200j ? 300k} lb and F 2 = {250i -...

The Black Star fund has assets with a market value of 1 2 . 6 million and liabilities of 8 0 0 , 0 0 0 . What is the net asset value if there are 2 0 0 , 0 0 0 shares outstanding

What combination of x and y will yield the optimum for this problem? Maximize $ 3 x + $ 1 5 y , subject to ( 1 ) 2 x + 4 y 1 2 and ( 2 ) 5 x + 2 y 1 0 . a . x = 0 , y = 3 b . x = 2 , y = 0 c . x = 1...

Explain the differences between the cognitive, behavioural, and environmental approaches to strategic employee development.

What are the organizational and employee benefits that result from a comprehensive onboarding process?

What shorter and longer-term career goals spark your interest?