Expand|Select|Wrap|Line Numbers
- create table jira_upload(id_num number,filename varchar2(50));
- insert into jira_upload values(1,'test');
Expand|Select|Wrap|Line Numbers
- 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;
Expand|Select|Wrap|Line Numbers
- set serveroutput on;
- exec sp_jira(id_req=> 1);