OraFAQ Forum: SQL & PL/SQL » ORA-12704: character set mismatch

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-12704: character set mismatch (Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit, MS WINDOWS Server 2008)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12704: character set mismatch [message #624994]

Tue, 30 September 2014 02:15

shahrir83
Messages: 1
Registered: September 2014
Location: Malaysia

Junior Member

Hi,

I encountered the above error while re-creating the following function.

SQL> create or replace FUNCTION p_LUChnlCfg_s_CAls_Ch_App_CAls
  2  (
  3    v_ConfigAlias IN VARCHAR2 DEFAULT NULL ,
  4    v_ChannelID IN NUMBER DEFAULT NULL ,
  5    v_ApplicationID IN NVARCHAR2 DEFAULT NULL ,
  6    cv_1 OUT SYS_REFCURSOR
  7  )
  8  RETURN NUMBER
  9  AS
10
11  BEGIN
12
13     OPEN  cv_1 FOR
14      WITH AppTree ( ApplicationID, RowID_ ) AS
15      ( SELECT ApplicationID , RowID_ FROM TABLE(Get_ApplicationHierarchy(v_ApplicationID))
16     UNION ALL
.
.
.
 
LINE/COL ERROR
-------- -----------------------------------------------------------------
14/3     PL/SQL: SQL Statement ignored
15/16    PL/SQL: ORA-12704: character set mismatch
 
Get_ApplicationHierarchy is referring to following table
SQL> desc tt_v_ApplicationHierarchy
Name                                  Null?    Type
------------------------------------- -------- ------------------
APPLICATIONID                         NOT NULL NVARCHAR2(50)
PARENTAPPLICATIONID                            NVARCHAR2(50)
ROWID_                                         NUMBER(10)

Appreciate feedback on this.

[Edit MC: add code tags and shorten long lines]

[Updated on: Tue, 30 September 2014 02:22] by Moderator

Report message to a moderator

Re: ORA-12704: character set mismatch [message #624996 is a reply to message #624994]

Tue, 30 September 2014 02:20

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Welcome to the forum.
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

ORA-12704: character set mismatch
 *Cause: One of the following:
         - The string operands(other than an nlsparams argument) to an
           operator or built-in function do not have the same character
           set.
         - An nlsparams operand is not in the database character set.
         - String data with character set other than the database character
           set is passed to a built-in function not expecting it.
         - The second argument to CHR() or CSCONVERT() is not CHAR_CS or
           NCHAR_CS.
         - A string expression in the VALUES clause of an INSERT statement,
           or the SET clause of an UPDATE statement, does not have the
           same character set as the column into which the value would
           be inserted.
         - A value provided in a DEFAULT clause when creating a table does
           not have the same character set as declared for the column.
         - An argument to a PL/SQL function does not conform to the
           character set requirements of the corresponding parameter.

Report message to a moderator

Previous Topic:	distribute grp_cd equally among the data
Next Topic:	group by to_char resulting in Exception: ORA-00979: not a GROUP BY expression

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 10 07:10:01 CDT 2024