This week's book giveaway is in the OCMJEA forum. We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line! See this thread for details.
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;
smitha, You have been asked at least once (in this topic) to change your diplay name to comply with JavaRanch standards. Please take a look at the JavaRanch Naming Policy and change your display name to match it. In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious. Please change your display name before your next post. Thanks! bear JDBC/JSP Forum Bartender