Macro in Password field of Run Oracle action
 

Hi,

Is it possible to use a %MACROVALUE% in the Password field of "Step Properties - Run Oracle Script"?

I am trying to run a oracle script that pull out a max value from one of the fields in the database and using it during the deployment.
Regards

Yes, just enter a macro reference like %MACROVALUE% as you would in any other field.

When I do enter %PASSWORD%, all it displays in the txt box is **** (astrix)...

is that correct behavior?

and How do I store a value in a MACRO..

for instance if I am doing

Select max(Field1) from table1.

I would like to store the output in a Macro .

Yes, by design, password fields are displayed with asterisks or circle to hide the value, like any Windows password field.

With the Run Oracle action, you would need to parse the value out of the LASTSTEP_OUTPUT macro into another macro, either in the next step (for instance, with the Read File action) or in the vbld_StepDone script event.
http://www.kinook.com/VisBuildPro/Ma...fileaction.htm
http://www.kinook.com/VisBuildPro/Ma...riptevents.htm