I created this procedure but I can not execute it. I have the following error when trying Execute:
PLS-00306: Incorrect number of argument types in call to 'SP_CARTAO'
CREATE OR REPLACE PROCEDURE SP_CARTAO
(
P_ID IN INT ,
P_ID_CARTAO OUT INT
)
AS
BEGIN
SELECT ID_CARTAO INTO P_ID_CARTAO
from log_cartao
where log_cartao.id_cartao = P_ID;
END;
EXECUTE SP_CARTAO(1);