Question

Please Explain why I am getting this error from the code below.

ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'P_PRODUCT_INFORMATION'

I have tried changing everything. Code is below.

Table to use:

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 VALUES(299,'Chest',99.99,10);

INSERT INTO ProductTable VALUES(300,'Wave Cruiser',49.99,11);

INSERT INTO ProductTable VALUES(301,'Megaland Play Tent',59.99,11);

INSERT INTO ProductTable VALUES(302,'Wind-Up Water Swimmers',2.00,11);

INSERT INTO ProductTable VALUES(303,'Garmin Pocket or Vehicle GPS Navigator',609.99,12);

----------------------------------------------------------------------------------------------------------------------------------------------

CREATE OR REPLACE PROCEDURE p_product_information(ID IN NUMBER, Name OUT VARCHAR)

AS

BEGIN

SELECT ProductName INTO Name

FROM ProductTable

WHERE ProductID=ID;

EXCEPTION
WHEN NO_DATA_FOUND THEN
dbms_output.put_line ('Product Id not found');
END;

/
EXECUTE p_product_information (300);

Answer 1

Dear Student ,

As per the requirement submitted above , kindly find the below solution.

This demonstration is using Oracle Live SQL.

Below is the correct way to execute the stored procedure.

Execute stored procedure:

declare
p_name varchar(20); /*declaring variable to store product name*/
begin
p_product_information(300, p_name); /*calling stored procedure*/
dbms_output.put_line(p_name);/*print the name*/
end;
/

Screen in Oracle Live SQL :

NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.