Parameters in Stored Procedure Stage

kamalshil · Post by **kamalshil** » Mon Feb 08, 2010 3:29 am

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?

bmarko22 · Post by **bmarko22** » Mon Feb 08, 2010 7:26 am

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

kamalshil · Post by **kamalshil** » Mon Feb 08, 2010 7:31 am

No they are not in quotes
they are like this

Code: Select all

#$username#

chulett · Post by **chulett** » Mon Feb 08, 2010 8:20 am

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

ray.wurlod · Post by **ray.wurlod** » Mon Feb 08, 2010 3:29 pm

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

kamalshil · Post by **kamalshil** » Tue Feb 09, 2010 12:24 am

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.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Feb 09, 2010 5:29 am

Do you get an oracle error code ?

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