Macro in Password field of Run Oracle action

[Shiamak]

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

[kinook]

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

[Shiamak]

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?

[Shiamak]

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 .

[kinook]

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

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

[kinook]

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 .
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/Manual/readfileaction.htm
http://www.kinook.com/VisBuildPro/Manual/scriptevents.htm