Question: Create a procedure that accepts product ID as a parameter and returns the price from ProductTable table. Add exception handling to catch if product ID

"Create a procedure that accepts product ID as a parameter and returns the price from ProductTable table. Add exception handling to catch if product ID is not in the table." Using Oracle SQL Developer.

Listed below is what is suppose to be outputed.

PROCEDURE P_PRODUCT_PRICE complied

anonymous block completed

Producr ID 302 $2

anonymous block completed

Producr ID 299 $99.99

anonymous block completed

No products with product ID13 is found

anonymous block completed

No products with product ID-45 is found.

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!

PRODUCT TABLE CREATE TABLE ProductTable( ProductID INTEGER NOT NULL primary key, ProductName VARCHAR(50) NOT NULL, ListPrice NUMBER(10,2), Category INTEGER NOT NULL ); / INSERT INTO ProductTable...

The following code will concatenate two strings str1 and str2 CREATE OR REPLACE PROCEDURE concatenate_strings as str1 VARCHAR2(25) := \'begin\'; str2 VARCHAR2(25) := \'end\'; result VARCHAR2(50);...

IN MYSQL... Part 1 The following code will concatenate two strings str1 and str2 CREATE OR REPLACE PROCEDURE concatenate_strings as str1 VARCHAR2(25) := 'begin'; str2 VARCHAR2(25) := 'end'; result...

The following code will concatenate two strings str1 and str2 CREATE OR REPLACE PROCEDURE concatenate_strings as str1 VARCHAR2(25) := 'begin'; str2 VARCHAR2(25) := 'end'; result VARCHAR2(50); BEGIN...

Create a procedure that accepts product ID as a parameter and returns the price from ProductTable table. Add exception handling to catch if product ID is not in the table. Using : Set SERVEROUTPUT...

PRODUCT TABLE CREATE TABLE ProductTable( ProductID INTEGER NOT NULL primary key, ProductName VARCHAR(50) NOT NULL, ListPrice NUMBER(10,2), Category INTEGER NOT NULL ); / INSERT INTO ProductTable...

Before you start this lab assignment, you have to run all examples from this module and understand the purpose of each line of code. You have to include the text of your code, not only screenshots....

Using Oracle SQL Create a procedure that accepts product ID as a parameter and returns the name of the product from ProductTable table. Add exception handling to catch if product ID is not in the...

I need help with the two problems below, I have also included the table necessary to complete the questions. CREATE TABLE ProductTable( ProductID INTEGER NOT NULL primary key, ProductName VARCHAR(50)...

USING ORACLE SQL DEVELOPER (please do not copy from other posts, the answers were not correct). 1. (3 points for code and screenshots of testing your code) The following code will concatenate two...

Consider the following: 1. a. Dow Chemical Companys annual report indicated that R&D expenditures were $1,646 million during 2011. How did this amount affect income before income taxes, which was...

In Problem, find each indicated quantity if it exists. Let Find (A) (B) (C) 3 2x-1 r +3x +2 lim f(x) lim, f(x) lim ay

A 1 5 - year Treasury bond is issued with face value of $ 1 , 0 0 0 , paying interest of $ 5 8 per year. If market yields increase shortly after the T - bond is issued, what is the bond s coupon rate?

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

=+ 2. You are trying to decide whether to take a vacation. Most of the costs of the vacation (airfare, hotel, and forgone wages) are measured in dollars, but the benefits of the vacation are...

=+ 3. You were planning to spend Saturday working at your part-time job, but a friend asks you to

=+ d. a professor deciding how much to prepare for class