create table jira_upload(id_num number,filename varchar2(50));
insert into jira_upload values(1,'test');
create or replace procedure sp_jira(
id_req IN jira_upload.id_num%type,
err_msg OUT varchar2)
as
lv_count number;
begin
select id_num into lv_count from jira_upload where id_num = id_req;
if lv_count is null then
err_msg := 'ID missing';
else
err_msg :='Success';
end if;
end;
set serveroutput on;
exec sp_jira(id_req=> 1);
I am getting below error while calling a procedure
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'SP_JIRA'