DSXchange

Hi,

I am parameterizing a oracle view and in my job i should execute a package in before sql and the value returned will be passed to the view which is called in the sql tab as a column generated query. The package execution and the view should be in a single oracle session. I think before sql and the sql queries in the SQL tab are treated as different oracle sessions.i am using the OCI stage in my job. Could you please let me know whether it is possible to achieve the requirement in a single session? One option is making the view query as user generated sql and before that the package should be executed.

Also please share your thoughts on datastage - oracle interactions in terms of oracle sessions.

Same session, yes - but you've got no way to pass any information between the two portions. You'll need two jobs.