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 :

Set SERVEROUTPUT ON;

Execute P_Product_Price (302);

Execute P_Product_Price (299);

Execute P_Product_Price (13);

Execute P_Product_Price (-45);

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!

Q:

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...

Q:

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);...

Q:

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...

Q:

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...

Q:

"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...

Q:

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...

Q:

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....

Q:

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...

Q:

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)...

Q:

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...

Q:

A chemical processing plant has a network of pipes that are used to transfer liquid chemical products from one part of the plant to another. The following pipe network has pipe flow capacities in...

Q:

What does it mean when a variance is favorable? What does it mean when a variance is unfavorable?

Q:

Federal Tax Deposit System ( LO 9 . 5 ) Hugo Inc. is a new business in 2 0 2 4 with seven employees. What is Hugo's default deposit status for employment taxes and withholding? a . Semiweekly b ....

Q:

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Q:

a lack of management responsibility concerning ecological issues and the utilization of scarce resources.

Q:

a neglect of quality in relationship to international competitors;

Q:

full employment policies, and therefore lack of concern with negative appraisal, as salaries varied very little and there was no danger of unemployment;