I tried to create following function:
CREATE OR REPLACE
function CATEGORYTEST(n in number) return VARCHAR(200)
IS
catname VARCHAR(200);
BEGIN
SELECT NAME AS PARENTCAT INTO CATNAME FROM CATEGORY_LANGUAGE WHERE CATEGORY_ID = (
SELECT PARENT_ID
FROM CATEGORY
WHERE ID = N
AND CAT_TYPE_ID = 7
AND IS_ACTIVE = 1
AND IS_DELETED = 0
)
AND IS_ACTIVE = 1
AND IS_DELETED = 0;
RETURN CATNAME;
end;
I am getting following error:
Error(2,51): PLS-00103: Encountered the symbol "(" when expecting one of the following: . @ % ; is authid as cluster order using external character deterministic parallel_enable pipelined aggregate
I had tried varchar2 also but getting same error.
JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)