stored procedure stage

samsuf2002 · Post by **samsuf2002** » Tue Jan 06, 2009 12:30 pm

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

lstsaur · Post by **lstsaur** » Tue Jan 06, 2009 3:43 pm

It's a bug; call your support.

samsuf2002 · Post by **samsuf2002** » Tue Jan 06, 2009 3:56 pm

Do I need a patch to fix this ?

ray.wurlod · Post by **ray.wurlod** » Tue Jan 06, 2009 5:21 pm

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.