How to use a sql plus variable when calling a script?

Question

I want to execute a powershell script from sqlplus which use a the variable a. As you can see if you execute this code, a isn't recognized. I would like this code to print 22, not a or :a

variable a varchar2;
a='22'
host powershell.exe echo :a
host powershell.exe echo a

:a

a

Alex Poole · Accepted Answer · 2022-06-02 07:23:46Z

1

You could use a substitution variable:

define a=22

host powershell.exe echo &a

If you already have the bind variable defined and populated by a process you don't want to change, you can set the substitution variable value using a dummy query and column ... new_value syntax.

answered Jun 2, 2022 at 7:23

Alex Poole

192k11 gold badges198 silver badges349 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to use a sql plus variable when calling a script?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related