Oracle OCI questions
Posted: Fri Jun 22, 2001 3:52 pm
Greetings,
Im running into issues with using Oracle with Oracle OCI stages
1. Some of my table access is through Public synonyms from other systems, I could pull the metadata for these tables through Manager. Should this work?
2. I can successfully run jobs with the OCI stage info hardcoded, specifically Database Source name, User Id and Password. Id prefer to use job parameters as I may have several jobs within a batch. With job parameters however, the job will compile but will not resolve the database connection. If I HC the source name, which may be ok, I cant resolve the user id/password with parameters. I know the parameter value are correct, because I cut/paste then into the exection
Any help would be appreciated. By the way, Im using DS 4.0 on a Sun/Solaris server. Thanks, Bob
Im running into issues with using Oracle with Oracle OCI stages
1. Some of my table access is through Public synonyms from other systems, I could pull the metadata for these tables through Manager. Should this work?
2. I can successfully run jobs with the OCI stage info hardcoded, specifically Database Source name, User Id and Password. Id prefer to use job parameters as I may have several jobs within a batch. With job parameters however, the job will compile but will not resolve the database connection. If I HC the source name, which may be ok, I cant resolve the user id/password with parameters. I know the parameter value are correct, because I cut/paste then into the exection
Any help would be appreciated. By the way, Im using DS 4.0 on a Sun/Solaris server. Thanks, Bob