I was executing one sql declare block. It has one input variable. While I was executing, it is asking for value, but next time onwards it is not asking, rather using the last value.
Please help me to clear this buffer memory.
I am herewith attaching the block.
var1 INTEGER := 0;
var1 := &&v;
for i in 1..var1 loop
In addition to this I have already used following commands to clear the buffer, but did not get any result.
1. alter system flush buffer_cache;
2. alter system flush shared_pool;
maybe you would be more successful if you knew what you use. In sqlplus, it is called substitution variable, and it is described in SQL*Plus User's Guide and Reference book. It is available with other Oracle documentation books e.g. online on http://tahiti.oracle.com/