Hi guys:
I have created a stroed func as follows:
CREATE OR REPLACE FUNCTION HR.worldCount(str IN VARCHAR2)
RETURN PLS_INTEGER
AS
BEGIN
Return 1;
END;
/
But an error occurs when I execute it:
Begin
DBMS_OUTPUT.PUT_LINE ('there are ' || HR.wordCount('abc'));
End;
Error is as follows:
Error at line 1 ORA-06550: line 2, column 39: PLS-00201: identifier 'HR.WORDCOUNT' must be declared ORA-06550: line 2, column 1: PL/SQL: Statement ignored
What is the issue?