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 with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Databases questions

Question

Question 2 An interfaces represents a class capability type method

Answered: 1 week ago

Question

What do you mean by dual mode operation?

Answered: 1 week ago

Question

Explain the difference between `==` and `===` in JavaScript.

Answered: 1 week ago