Character Set Problem in ORAOCIBL
Posted: Mon Aug 09, 2004 1:57 am
We are getting the following error message while
trying to load data to an Oracle9i database using the
ORAOCIBL stage. We are on Datastage 6.1 on a Windows
2000 server.
Test9i..ORAOCIBL_3: Internal Error:Unable to
initialize the Direct Path Context
ORA-24329: invalid character set identifier.
We recently migrated from Oracle 8i to Oracle 9i and
the Oracle 9i database's character set is
WE8ISO8859P1. We have been loading data to the Oracle
8i database all these days and the character set
defined in the 8i database is US7ASCII. The DBA
refuses to change the newly defined character set and
is instructing us to make the necessary changes in the
Datastage server.
We followed the instructions is the Oracle
Documentation and modified the environment and
character set in the Datastage server (Windows 2000)
but still continue to get the same error message.
Would be happy to get support from people who have
faced this problem before and were able to rectify it.
trying to load data to an Oracle9i database using the
ORAOCIBL stage. We are on Datastage 6.1 on a Windows
2000 server.
Test9i..ORAOCIBL_3: Internal Error:Unable to
initialize the Direct Path Context
ORA-24329: invalid character set identifier.
We recently migrated from Oracle 8i to Oracle 9i and
the Oracle 9i database's character set is
WE8ISO8859P1. We have been loading data to the Oracle
8i database all these days and the character set
defined in the 8i database is US7ASCII. The DBA
refuses to change the newly defined character set and
is instructing us to make the necessary changes in the
Datastage server.
We followed the instructions is the Oracle
Documentation and modified the environment and
character set in the Datastage server (Windows 2000)
but still continue to get the same error message.
Would be happy to get support from people who have
faced this problem before and were able to rectify it.