Home

Rule description

• Positional and named arguments should not be mixed in invocations

Non-compliant Code Example

CREATE PROCEDURE GetTotalExpense(invoice_amount1 NUMBER,invoice_amount2 NUMBER)
As
BEGIN
	DBMS_OUTPUT.PUT('Total expense amount is'|| (invoice_amount1 + invoice_amount2));
END;

BEGIN
	GetTotalExpense(1520,invoice_amount2=>633);         --Non compliant code (Positional and named arguments are mixed in the invocations)
	GetTotalExpense(invoice_amount1=>1520,633);         --Non compliant code (Positional and named arguments are mixed in the invocations)
END;

Compliant Code Example

CREATE PROCEDURE GetTotalExpense(invoice_amount1 NUMBER,invoice_amount2 NUMBER)
As
BEGIN
	DBMS_OUTPUT.PUT('Total expense amount is'|| (invoice_amount1 + invoice_amount2));
END;

BEGIN
	GetTotalExpense(1520,633);
	GetTotalExpense(invoice_amount1=>1520,invoice_amount2=>633); --Compliant code (Positional and named arguments are separates in invocations)
END;