Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011
    Posts
    1

    Unanswered: How to clear Buffer memory

    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;

  2. #2
    Join Date
    Mar 2007
    Posts
    623
    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)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •