Dovberman
asked on
Oracle PL/SQL Function Syntax
This is a simple function that I copied from a tutorial.
The following error is triggered when I try to compile:
"The name in the text editor differs from the specified object name"
Here is the function:
This statement executes in the SQL window:
SELECT ename
FROM employee WHERE EmpNo = 6;
What am I missing?
Thanks,
The following error is triggered when I try to compile:
"The name in the text editor differs from the specified object name"
Here is the function:
CREATE OR REPLACE FUNCTION DBM_Add_ColComment
RETURN VARCHAR(20);
IS
emp_name VARCHAR(20);
BEGIN
SELECT ename INTO emp_name
FROM employee WHERE EmpNo = 6;
RETURN emp_name;
END;
/
This statement executes in the SQL window:
SELECT ename
FROM employee WHERE EmpNo = 6;
What am I missing?
Thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you,
ASKER
Thanks,