472,119 Members | 1,623 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,119 software developers and data experts.

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
Sep 23 '21 #1
1 4919
pritikumari
23 16bit
CREATE OR REPLACE PROCEDURE createUser
(corpId IN VARCHAR2, passwd IN VARCHAR2) IS
-- [declaration_section]\
DDL_STMT VARCHAR2(400);
BEGIN
-- executable_section
DDL_STMT:= 'CREATE USER "'|| corpId || '" IDENTIFIED BY "' || passwd || '" DEFAULT TABLESPACE RDSADMIN TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK';
DBMS_OUTPUT.PUT_LINE('DDL STATEMENT EXECUTED:'||DDL_STMT);
EXECUTE IMMEDIATE DDL_STMT;
END;
Feb 16 '23 #2

Post your reply

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

Similar topics

reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.