SQL*Plus: How to check if a bind variable is already declared? [message #683202] |
Mon, 14 December 2020 03:47 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
My question is in the title.
Background:
I have a SQL*Plus script in which I have to know if a bind variable is already declared or not and in the later I have to declare and assign it a default value.
If the bind variable already exists and has a non-null value, I want to keep it.
One more point: I work on Windows.
It can be done for a substitution variable but can it be for a bind variable?
[Updated on: Mon, 14 December 2020 11:14] Report message to a moderator
|
|
|
|