DSXchange

Hi

I'm trying to select data using OCI 8 stage ( Source ) with the query type option as Load SQl from a file at run time.

I'm able to see the oracle session has completed ...but the control is not back to datastage.

The job is still running with no data selected.

Im using datastage 7.5.1A

Suggestions please....

Loading the sql at runtime from a file doesn't fundamentally change how queries behave. Meaning it will behave the same as if you'd entered that query in the stage itself, so that in and of itself isn't the issue here.

suresh.narasimha wrote:I'm able to see the oracle session has completed ...but the control is not back to datastage.

How are you seeing 'the session has completed'?

Hi Chulett

I can see my session completed from Oracle Enterprise manager.

Right. I meant define 'complete'. Session not active? Cursors closed? What does your DBA say is going on? Or is that you? Seeing as how you have OEM.