Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Getting error while calling procedure

Albert ChaoSep 23 2021
 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'

This post has been answered by mathguy on Sep 23 2021
Jump to Answer

Comments

Elco

It are not the tables :

CSF_ACCESS_HOURS_B

CSF_ACCESS_HOURS_TL

Elco

I don't know how I can do the relation with party_id and customer_name

I have now this SQL code:

SELECT

       hp.party_name

     , hca.account_number

     , hca.cust_account_id

     , hp.party_id

     , hl.address1

     , hl.address2

     , hl.address3

     , hl.city

     , hl.state

     , hl.country

     , hl.postal_code

         

FROM   hz_parties hp

     , hz_party_sites hps

     , hz_locations hl

     , hz_cust_accounts_all hca

     , hz_cust_acct_sites_all hcsa

     , hz_cust_site_uses_all hcsu

WHERE  hp.party_id = hps.party_id

AND    hp.party_id = hca.party_id

AND    hcsu.cust_acct_site_id = hcsa.cust_acct_site_id

AND    hca.cust_account_id = hcsa.cust_account_id

Elco

Does anybody has an idea?

Thanks in advange

Regards

Elco

1 - 3

Post Details

Added on Sep 23 2021
8 comments
453 views