Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

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
image text in transcribed
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

Step: 1

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Online Market Research Cost Effective Searching Of The Internet And Online Databases

Authors: John F. Lescher

1st Edition

0201489295, 978-0201489293

More Books

Students explore these related Databases questions

Question

What do you mean by dual mode operation?

Answered: 3 weeks ago