oracle 重载问题：错误（83,5）：PLS-00307：太多的“REPORTEQ”声明与此调用匹配
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/6010069/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Overloading problem: Error(83,5): PLS-00307: too many declarations of 'REPORTEQ' match this call
提问by Richard Knop
So I am trying to use overloading but I am having some troubles. My package has 4 procedures with the same name but different type of arguments (VARCHAR2, NUMBER, BOOLEAN, DATE). The package header and package body are at the end of my question.
所以我试图使用重载，但我遇到了一些麻烦。我的包有 4 个同名但参数类型不同的过程（VARCHAR2、NUMBER、BOOLEAN、DATE）。包头和包体在我的问题的末尾。
I am trying to use the package procedure like this:
我正在尝试使用这样的包过程：
OPEN bookCountCur;
FETCH bookCountCur INTO how_many;
testutil.reporteq('add procedure, book record count',
expected_value => '1', actual_value => how_many);
CLOSE bookCountCur;
OPEN copiesCountCur;
FETCH copiesCountCur INTO how_many;
testutil.reporteq('add procedure, book copy record count',
expected_value => '1', actual_value => how_many);
CLOSE copiesCountCur;
And I am getting this compilation error:
我收到此编译错误：
Error(83,5): PLS-00307: too many declarations of 'REPORTEQ' match this call
What does it mean?
这是什么意思？
Package header:
包头：
CREATE OR REPLACE
PACKAGE TESTUTIL AS
/* TODO enter package declarations (types, exceptions, methods etc) here */
PROCEDURE reporteq(description IN VARCHAR2
, expected_value IN VARCHAR2, actual_value IN VARCHAR2);
PROCEDURE reporteq(description IN VARCHAR2
, expected_value IN NUMBER, actual_value IN NUMBER);
PROCEDURE reporteq(description IN VARCHAR2
, expected_value IN BOOLEAN, actual_value IN BOOLEAN);
PROCEDURE reporteq(description IN VARCHAR2
, expected_value IN DATE, actual_value IN DATE);
END TESTUTIL;
And the package body:
和包体：
CREATE OR REPLACE
PACKAGE BODY TESTUTIL AS
PROCEDURE reporteq(description IN VARCHAR2
, expected_value IN VARCHAR2, actual_value IN VARCHAR2) AS
BEGIN
DBMS_OUTPUT.PUT(description || ': ');
IF expected_value = actual_value
OR expected_value IS NULL AND actual_value IS NULL
THEN
DBMS_OUTPUT.PUT_LINE('PASSED');
ELSE
DBMS_OUTPUT.PUT_LINE('FAILED. Expected ' || expected_value || '; got ' || actual_value);
END IF;
END reporteq;
PROCEDURE reporteq(description IN VARCHAR2
, expected_value IN NUMBER, actual_value IN NUMBER) AS
BEGIN
DBMS_OUTPUT.PUT(description || ': ');
IF expected_value = actual_value
OR expected_value IS NULL AND actual_value IS NULL
THEN
DBMS_OUTPUT.PUT_LINE('PASSED');
ELSE
DBMS_OUTPUT.PUT_LINE('FAILED. Expected ' || expected_value || '; got ' || actual_value);
END IF;
END reporteq;
PROCEDURE reporteq(description IN VARCHAR2
, expected_value IN BOOLEAN, actual_value IN BOOLEAN)
AS
expected_value_tostr VARCHAR2(5);
actual_value_tostr VARCHAR2(5);
BEGIN
DBMS_OUTPUT.PUT(description || ': ');
IF expected_value = actual_value
OR expected_value IS NULL AND actual_value IS NULL
THEN
DBMS_OUTPUT.PUT_LINE('PASSED');
ELSE
/* Transform TRUE/FALSE to 'TRUE'/'FALSE' */
IF TRUE = expected_value
THEN
expected_value_tostr := 'TRUE';
ELSE
expected_value_tostr := 'FALSE';
END IF;
IF TRUE = actual_value
THEN
actual_value_tostr := 'TRUE';
ELSE
actual_value_tostr := 'FALSE';
END IF;
DBMS_OUTPUT.PUT_LINE('FAILED. Expected ' || expected_value_tostr || '; got ' || actual_value_tostr);
END IF;
END reporteq;
PROCEDURE reporteq(description IN VARCHAR2
, expected_value IN DATE, actual_value IN DATE) AS
BEGIN
DBMS_OUTPUT.PUT(description || ': ');
IF expected_value = actual_value
OR expected_value IS NULL AND actual_value IS NULL
THEN
DBMS_OUTPUT.PUT_LINE('PASSED');
ELSE
DBMS_OUTPUT.PUT_LINE('FAILED. Expected ' || TO_CHAR(expected_value, 'YYYY/MM/DD')
|| '; got ' || TO_CHAR(actual_value, 'YYYY/MM/DD'));
END IF;
END reporteq;
END TESTUTIL;
回答by DCookie
What type is your PL/SQL variable how_many? It needs to be a VARCHAR2, else expected_value needs to be a NUMBER. Try this:
您的 PL/SQL 变量how_many是什么类型？它必须是 VARCHAR2，否则 expected_value 必须是 NUMBER。尝试这个：
testutil.reporteq('add procedure, book record count',
expected_value => '1', actual_value => TO_CHAR(how_many));
The problem is (assuming how_manyis a numeric type) is that you don't have a spec that matches a VARCHAR2 and a NUMBER parameter list. You've got VARCHAR2/VARCHAR2, NUMBER/NUMBER, VARCHAR2/BOOLEAN, and DATE/DATE.
问题是（假设how_many是数字类型）是您没有匹配 VARCHAR2 和 NUMBER 参数列表的规范。您有 VARCHAR2/VARCHAR2、NUMBER/NUMBER、VARCHAR2/BOOLEAN 和 DATE/DATE。
回答by Lukas Eder
Does casting '1'to VARCHAR2do the trick? I.e.:
铸造'1'可以解决问题VARCHAR2吗？IE：
testutil.reporteq('add procedure, book record count',
expected_value => cast('1' as VARCHAR2), actual_value => how_many);
I think the literal '1'can be seen as a VARCHAR2, or a NUMBER, or maybe even a BOOLEANby the PL/SQL compiler...
我认为文字'1'可以被PL/SQL 编译器视为 a VARCHAR2，或 a NUMBER，甚至可能是 a BOOLEAN......
