DSXchange

Hi
Do you know of a way to call oracle stored procedure without supplying user name and pwd ?
On the oracle stage there's a check box "use os level authentication" that works
Thank's

If you google "sqlplus with no password" you should get some hits on how this might be done. Most likely the quickest is to use a very restricted user and password that can be made public, i.e. User "restricted", password "restricted" that can only do those queries that you specify.
Otherwise you could use scripts available on the internet to grant access without making the password visible.

The stored procedure can be accessed via sqlplus from the server, what kind of configuration should we implement on DataStage?

I don't have access right now to DataStage to test out what you ask, perhaps someone else might know the answer.

asaf_arbely wrote:On the oracle stage there's a check box "use os level authentication" that works

??

When accessing oracle DB via oracle stage the check box "use os level authentication" enables to connect the DB without supplying user name and pwd.
On the stored procedure stage that kind of configuration is missing

Right... so why not use the Oracle stage to "call" the stored procedure?

There's nothing documented except here, I believe. You can put "call sp_name" either before or after sql, typically before if the sproc is a target. Then you'll need something that does 'nothing' in the actual sql tab - delete or modify something you know will never succeed, this as a 'no-op' since the goal is to simply execute the before-sql.