character encoding - Accessing a Function over Database Link with Different Charsets in Oracle -


I have a function in the DatabaseA, which I want to use in DatabaseB, so I created a DB link in databaseb, and As a function,

  SELECT function_name @ dblink ('A0484') with double;  

This did the following error

  error in line 1: ORA-12703: This character set conversion Ora-06512: is not supported on line 1  

I found the database information on excavation

  databases: version-8i charset-US 7 ASCII databasebase version 10G charset-ALURUTF 8  

Direct access to any table of database B from DatabaseB finishes through DBLink, this is the only function that Gives this error.

Function is similar to a signature below

  Create or reinstate work TestFunc (p_Number IN VARCHAR2) Returns VARCHAR2 has returned to 'some data'; End;  

What can be done to avoid the conversion error and what is wrong, which can cause any idea as the direct access to the tables starts working properly. This is a known Oracle bug - see note 237593.1 if you have access to MetLink. The recommended solution is to use the UTF 8 character set for the 10G database when you connect to a 9-prior client (remember that the 8i database is "client" of 10 gram database in this case). Alternatively, there is an 8i patch that can work.


Comments