CODEWITHSUNDEEP
oracle-databaselineora-06550
Zeeshan
Zeeshan

Reputation: 1

ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to

When call a parameter show this error what is the issue I don't understand. I am new user :-(

CREATE OR REPLACE PROCEDURE cust_order_sample
( 
order_po_num IN Number,
sale_order_num OUT Number
)
As
BEGIN
select CONTROLLING_MANAGER INTO sale_order_num from FND_CONC_REQ_SUMMARY_V  WHERE ARGUMENT_TEXT=order_po_num;
END 
cust_order_sample;

And when I run this procedure: 

execute cust_order_sample(28685);

I get this error:

ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'CUST_ORDER_SAMPLE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Upvotes: 0

Views: 2260

Answers (1)

OldProgrammer
OldProgrammer

Reputation: 12169

You need to create a bind variable to store the OUT parameter value. In SQLPLUS, this will work:

var nvar number;
execute cust_order_sample(111, :nvar);
print nvar;

Upvotes: 2

Related Questions