Hi,
I have a PL-SQL function that returns a
string. The return string contains two strings separated by a unicode character (example AA�BB). My code returns AB\u00fdBB instead of AA�BB. How to insert a unicode character in PLSQL? My code is as under. M
Appreciate if some one helps me out in this regard.
Thanks in advance,
Smitha
============================================================================
FUNCTION getValue(strA VARCHAR2, strB VARCHAR2)RETURN VARCHAR2
AS
v_unicode VARCHAR2(10) := '\u00fd';
v_out VARCHAR2(50);
BEGIN
v_out strA || v_unicode || strB;
DBMS_OUTPUT.PUT_LINE(v_out);
RETURN v_out;
END getValue;