Question: PL/SQL What does the following code do ? Replace the error messages error1 and error2 with more meaningful messages. CREATE OR REPLACE PROCEDURE add_new_supplier (supplier_id_in

PL/SQL

What does the following code do ? Replace the error messages "error1" and "error2" with more meaningful messages. CREATE OR REPLACE PROCEDURE add_new_supplier (supplier_id_in IN NUMBER, supplier_name_in IN VARCHAR2) Is BEGIN INSERT INTO suppliers (supplier_id, supplier_name ) VALUES ( supplier_id_in, supplier_name_in ); EXCEPTION WHEN DUP_VAL_ON_INDEX THEN raise_application_error (-20001, 'error 1.'); WHEN OTHERS THEN raise_application_error (-20002, 'error 2.' ); END

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!

CCIT 4 2 6 : Database - 2 Lab 6 : Exception Handling and Triggers LAB 6 Content PL / SQL - Records In this chapter, we will discuss Records in PL / SQL . A record is a data structure that can hold...

Please write a PLSQL code for the following SQL PLSQL Question Please Use the following code and provide both SQL and PLSQL Statements Code 1(Step 1) https://codeshare.io/2EMK1o Code 2 (Step 2)...

ASSIGNMENT #2 SECTION A Using Scalar Variables Create a PL/SQL block containing the following variables : NAME DATA TYPE OPTION INITIAL VALUE lv_test_date DATE December 10, 2012 lv_test_num NUMBER...

CREATE TABLE " ACTOR " ( "ID" NUMBER(9,0) NOT NULL, "NAME" VARCHAR2(100) NOT NULL, CONSTRAINT ACTOR_PK PRIMARY KEY (ID)); CREATE TABLE " MOVIE " ( "ID" NUMBER(9,0) NOT NULL, "TITLE" VARCHAR2(100) NOT...

Using the following relations: Patients(pid, name, address, telephone, care_centre_id) Care_centres(cid, name, location, nurse_charge_id) Treatments(tid, patient_id, physician_id, treatment_name,...

Write a PL/SQL block with the following specifics: Create a variable that will be used to contain a salary amount. Make it a constant with an intital value of 10000. Try several values for this...

Write a PL/SQL block to the following questions. I have attached the ERD to help with the problems. Thank you. Tell me what you want to do Insert Draw Design Layout References Mailings Review View Be...

Use a cursor in PL/SQL to generate the following *: Invoice Overdue! Invoice Number: 113 Invoice due date: 20-JUL-14 Amount Due: $21842 Invoice Overdue! Invoice Number: 114 Invoice due date:...

Hello this question is for 3 parts please answers all of them it must be continue because all questions linked like 1.2-1.3 ... A hairdresser needs a database with information about customers,...

A hairdresser needs a database with information about customers, services, reservations, employees and their shifts. Based on this information we are supposed be able to: 2. Program PL/SQL procedure...

describes the net present value of the stream of future profits expected over the customer's lifetime purchase Select one: a. Activity-based costing b. Customer lfetime value c. Customer value...

3 Which of the following vectors is orthogonal to 2 () -1 2 (3) -2 () 1

Information is designed to meet the specific needs of a company's management is referred to as: Financial Accounting Managerial Accounting Planned Accounting Strategic Accounting

Scenario: A Multi-national Corporation called The Globe has created a subsidiary called Thirst in an under-developed country called non-potable waters. This hosting country suffers from a severe...

(Appendices) PURCHASES, PURCHASE RETURNS, AND PAYMENT FOR PURCHASES. Jordan Footwear sells athletic shoes. During April Jordan made the following purchases on credit with terms 3/15, n/40: LO4 Assume...

(Appendices) A CLASSIFIED INCOME STATEMENT FOR A MERCHANDISING BUSINESS. For each of the cases presented below, compute the missing amounts: LO8

(Appendices) PURCHASES, TRANSPORTATION-IN, AND PURCHASE RETURNS. Alpharack Company sells a line of tennis equipment to retailers. Alpharack uses periodic inventory accounting. Alpharack engaged in...