DSXchange

That's usually means a lack of execute grants for the connecting user.

Use the 'Preview' button to see what your post will look like before submitting it. The forum software removes all 'excess' whitespace unless you use

esivaprasad wrote:installed only 7.5 version,still giving same error.

That's an important piece of information. What operating system are you installing this on?

Which means the batch file is getting executed but based on the speed, it sounds like it failing to call sqlplus properly from inside the batch. That comes down to either making sure your PATH is correct or using an absolute path to sqlplus. Note that your command shows you passing what look like re...

rodre wrote:the bat files call commands like this:
call sqlldr %1/wh1@%2 control=Data\ContCol.ctl data=Data\ContColl.dat
Which, if I understand correctly, it creates a file for oracle to upload.

No, it loads the already created .dat file into Oracle.

Then they are failing to run or failing to be found because as noted they are synchronous operations. Are you using absolute paths?

No, there's no conversion of job type, just an automatic upgrade of the version of the jobs.

Do you need to do a bulk load? What kind of load volume are we talking about?

FWIW, I checked the 8.5 docs for both the stage and the operator and found no reference to any 'wildcard' character.

If you run the script from DataStage then there's no need to pass anything, they will be in the environment. Just reference them like any other environment variable.

Advise you contact your official support provider.

It does work fine 'Before SQL' in a Server OCI stage. Are you connecting as the owner? Or code in a dummy parameter and call it from the SP stage.

Are you using the Multi-Client Manager to switch between the two? You can have them both installed but only one can be active at any given time, hence the need to switch using MCM.

Did you do that in job before the parsing or manually?

Still curious what a DUMP() would show...