this is my project A company want to allow customers to do product search by selecting a product name or description, and then typing a search term.

this is my project

A company want to allow customers to do product search by selecting a product name or description, and then typing a search term. Using native dynamic SQL, create a procedure name SEARCH_SP that returns a product name, description, and price base on users' search criteria. The procedure needs handle multiple rows being returned.

and here what i did but it gives me errors. please solve it for me.

CREATE OR REOLACE PROCEDURE SEARCH-SP (product_name IN VARCHAR2,