tags:

views:

22

answers:

0

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?