How do I Remove a value stored with && ?

[kmesser]

In SQL*PLUS, I'm developing a procedure. As part of the procedure, I have a value I wish to prompt for once, then use repeatedly. Now I don't get prompted any more and I need to change the value.

declare

cursor x is select * from mytable where id = &&ID

begin
. . .
end;
/

How can I "undefine" this value?

[shawish_sababa]

Hi

as far as i know, you can define a parameter an the start of the procedur as an IN parameter, or you can read from a text file useing utl_file. you have no & in a procedur becouse this is used for run time parameters when you do not create an object on the database.

[mstarkman]

Use the SQL*Plus undefine command.

ex. - undefine ID