DSXchange

Hi All,
I am trying to call 1 stored procedure from datastage job.
But if in any of feild for database,password,username or schemaname if i give job parameter.
i am getting fatal error.
TNS-ORA-Could not resolve.

And if i do hard coding it is working fine.

So how do i use job parameters in stored procedure stage?

If you have the parms in quotes take them out. Fixed it for us.

No they are not in quotes
they are like this

And you actually have a job parameter defined in the job named '$username' - all lower-case, just like that?

The "$" character will cause DataStage to seek out an environment variable in the project. Is that how your project is set up?

ray.wurlod wrote:The "$" character will cause DataStage to seek out an environment variable in the project. Is that how your project is set up? ...

Yes.

Do you get an oracle error code ?

Include a command stage to echo the value for oracle connection string.