469,342 Members | 5,849 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,342 developers. It's quick & easy.

Getting wrong number or types of arguments in call to 'SP_JIRA' error while calling a stored procedure

Expand|Select|Wrap|Line Numbers
  1. create table jira_upload(id_num number,filename varchar2(50));
  2.  
  3. insert into jira_upload values(1,'test');
Expand|Select|Wrap|Line Numbers
  1. create or replace procedure sp_jira(
  2. id_req IN jira_upload.id_num%type,
  3. err_msg OUT varchar2)
  4. as
  5. lv_count number;
  6. begin
  7.  
  8. select id_num into lv_count from jira_upload where id_num = id_req;
  9.  
  10. if lv_count is null then
  11. err_msg := 'ID missing';
  12. else
  13. err_msg :='Success';
  14. end if;
  15. end;
  16.  
Expand|Select|Wrap|Line Numbers
  1. set serveroutput on;
  2. exec sp_jira(id_req=> 1);
I am getting error
4 Weeks Ago #1
0 431

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.