Which is the suitable routine to get max value from query?

[bala.vimalan]

I want to select Max/Count value through a query from one oracle table in sequence job. To achieve this, I am planning to write a routine and call it in User variable stage and assign it to one variable.

Here I do not now know, which routine suits to call from user variable activity stage.

[chulett]

You could use a Server job and USERSTATUS. Or a routine using DSExecute to run either a script (more control) or call sqlplus directly.