Using Oracle SQL Developer, \"Create a procedure that accepts product ID as a pa

Question

Using Oracle SQL Developer, "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."

The table ProductTable already exists.

The Sccript Output is

PROCEDURE P_PRODUCT_PRICE compiled

anonymous block completed

Product ID 302 $2

anonymous block completed

Product ID 299 $99.99

anonymous block completed

No products with product ID13 is found

anonymous block completed

No products with product ID-45 found

Explanation / Answer

We can call the procedure price_from_product in this way from a PL/SQL Block.

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.