Hi,
I have the script below:
----------------------------------------------------------
CREATE OR REPLACE FUNCTION uf_getInnerText(expr in varchar2, tagname in varchar2)
RETURN varchar2 is
begin
declare
begin_tag varchar(20) := '<' + tagname + '>' ;
end_tag varchar(20) := '</' + tagname + '>' ;
tagnameLength number := length(tagname) + 2;
innerText varchar(20) := SUBSTR(expr, instr(expr, begin_tag) + tagnameLength, instr(expr, end_tag) - instr(expr, begin_tag) - tagnameLength);
return innerText;
END uf_getInnerText;
-------------------------------------------------------------
It's getting the error
19/1 PLS-00103: Encountered the symbol "END" when expecting one of the following: begin function pragma procedure subtype type <an identifier> <a double-quoted delimited-identifier> current cursor delete exists prior
Errors: check compiler log
Please advise.
Thanks!