Error on function in PL/SQL

Question

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)

Answer 1

Try this: CREATE OR REPLACE FUNCTION CATEGORYTEST( n IN NUMBER ) RETURN VARCHAR2 IS catname VARCHAR2(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 CATEGORYTEST; You needed single quotes around your string literals, VARCHAR changed to VARCHAR2 and some other small changes. BTW, your catname variable would be better declared as: catname CATEGORY_LANGUAGE.NAME%TYPE; You might also want to look into the return type of the function also being flexibly declared e.g.: RETURN CATEGORY_LANGUAGE.NAME%TYPE Hope it helps...