|
|
|
|
|
|
|
Re: Having multiple input values [message #502374 is a reply to message #502371] |
Wed, 06 April 2011 02:39 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
It works as expected:
*First* the stuff you wrote is parsed in SQLPlus, and the &a is replaced by the 10.
*Then* the entire PL/SQL Block is send to the server, and executed on the server. Since PL/SQL runs on the server, there is no way to have additional client inputs inside PL/SQL.
|
|
|
Re: Having multiple input values [message #502375 is a reply to message #502371] |
Wed, 06 April 2011 02:40 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![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: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
SQL*Plus works on the client.
SQL*Plus analyzes what you give and asks for values if anyone is needed.
Then SQL*Plus sends the PL/SQL block (in this case) to the server after substituting the (subsitution) variables by their values (you can see it by the old/new lines).
PL/SQL works on the server.
When the block is completed, PL/SQL returns the result to SQL*Plus/
SQL*Plus displays the result.
In short, a PL/SQL block does not interact with the client, it is a whole, executed as a whole.
Regards
Michel
[Updated on: Wed, 06 April 2011 02:41] Report message to a moderator
|
|
|
|