Hi,

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.

declare

var1 INTEGER := 0;
begin

var1 := &&v;

dbms_output.put_line(var1);

for i in 1..var1 loop

dbms_output.put_line(i);

end loop;

end;

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;

Hi,

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/

For undefining it, you should use UNDEFINE sqlplus command. For 11gR2 (it would be nice if you posted your Oracle version), it is described here: http://docs.oracle.com/cd/E11882_01/...9.htm#i2699781

(maybe you are using other client than sqlplus; in that case, consider consulting its online help about substitution variables; it should be accessible from menu or by F1 button)