Home » Developer & Programmer » Data Integration » ORA-31466: no publications found
ORA-31466: no publications found [message #166037] Tue, 04 April 2006 03:38
dash_ajit
Messages: 1
Registered: April 2006
Junior Member
When I execute

BEGIN
DBMS_CDC_SUBSCRIBE.SUBSCRIBE(
subscription_name => 'C1_SUB',
source_schema => 'R1',
source_table => 'C1啊',
column_list => 'COL1埃, COL2唉',
subscriber_view => 'C1_VIEW');
END;

with chinese characters in table name and column name against
Oracle 10.2.0.1.0 database

I got following error

<ORA-31466: no publications found
ORA-06512: at "SYS.DBMS_CDC_ISUBSCRIBE", line 10
ORA-06512: at "SYS.DBMS_CDC_SUBSCRIBE", line 135
ORA-06512: at line 1

I have set NLS_LANG to

SIMPLIFIED CHINESE_CHINA.ZHS16GBK

If I use American English Characters, There is absolutely no issue.

What is the problem?
Previous Topic: OWB Message: API4020: The database link type is not consistent with the module type
Next Topic: Is Runtime Parameter parameter variable can be used in mapping?
Goto Forum:
  


Current Time: Thu Mar 28 10:09:46 CDT 2024