Oracle enterprise dboption error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
KPReddy
Participant
Posts: 28
Joined: Wed Jan 25, 2006 12:41 pm
Location: Philadelphia,PA

Oracle enterprise dboption error

Post by KPReddy »

Hi,
I am able to connect to Oracle database using "ODBC Enterprise" stage but when i try to connect using "Oracle enterprise" stage i am getting the error.

Incorrect dboption list; it failed on Expected "," or "}", got: "$", line 1

Please help.
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Do you have any special character like '$' in you user id or password?
Have you tried enabling $DS_ENABLE_RESERVED_CHAR_CONVERT to true in your job?
Have you tried searching for the same error in the forum?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
KPReddy
Participant
Posts: 28
Joined: Wed Jan 25, 2006 12:41 pm
Location: Philadelphia,PA

Post by KPReddy »

Thanks Kumar. But DS_ENABLE_RESERVED_CHAR_CONVERT applies for column names. How to get around it in user id.
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Try to apply patch from the Ecase 84857. Or Search for the same.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Post Reply