Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Replication Agent and selecting field names with special characters from Oracle PDS

Hello All,

I have SAP Replication Server SP200 set up and working from Oracle to HANA. I'm creating a subscription with the direct_load option on the SAP table MARA. This is failing at the "SELECT" stage with the Oracle error "ORA-00936: missing expression". This is because the MARA table contains a few fields that begin with a forward slash e.g. /BEV1/LULEIHN. In order for this to work each field name needs to be enclosed in double quotes ("/BEV1/LULEIHN"). Does anybody know if there is an option in Replication Server to make it use double quotes in select statements?

If not I'll end up creating views for all the tables containing special characters.

Thanks

Matt

Former Member
Former Member replied

Hello,

I've now got this working but setting the dsi_quoted_identifier to "always" when creating both primary and replicate connections. The syntax I used was as follows:


create connection to pds.pdb

using profile <profile_name>

set username <username>

set password <password>

set dsi_quoted_identifier to "always"

go

Thanks

Matt

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question