Hi , I am using a stored procedure stage in my PX job for oracle db, i want to specify environmental variable for the data source and data base fields. I gave $dbname for database field its working fine but when I use $dbsource for data source field its aborting with this error
"Error: ORA-12154: TNS:could not resolve the connect identifier specified"
"Resource bundle corresponding to message key DSTAGE-TODC-00017 not found! Check that DSHOME or APT_RESPATH is set."
Job run fine if i hardcode the values in the stored proc stage. Can anyone help me on this ?
Thanks
stored procedure stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
stored procedure stage
hi sam here
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Your support provider will advise. They, in turn, will need to investigate whether it's a known bug or a new one and, if the former, whether there exists a patch. We (the posters at DSXchange) do not have the resources to do those things.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.