oracle10g - SQLPlus 's weird reaction during DML statements execution -

oracle10g - SQLPlus 's weird reaction during DML statements execution -

today executing dml statements sql file in sqlplus, oracle 10.2, found weird question "enter value hamburger:". see attached

and ending of question "enter value xxx" kept alter intervals. mean after few seconds found statement "enter value mcdonald"....

i want know normal sqlplus ????

i have tried execute dml statement giving location of sql file in sqlplus.

sql>@/tmp/mydir/dmls.sql;

an exemplary statement sql file

insert myschema.mytable (id,dix_dir_id,dix_agl,dix_xml_inline) values (23202,1100080319000620471,'directory','<values> <dir_class_title>person</dir_class_title> </values> ');

you have ampersand in statement.

when sql*plus encounters ampersand, tries replace defined to. if undefined, prompts value:

this statment without ampersand:

sql> select 'foo' dual; 'fo --- foo

now, statement ampersand. value foo not (yet) defined, prompts one:

sql> select '&foo' dual; come in value foo: bla old 1: select '&foo' dual new 1: select 'bla' dual 'bl --- bla

now, foo defined bar:

sql> define foo=bar

the select statement (with &foo) returns bar:

sql> select '&foo' dual; old 1: select '&foo' dual new 1: select 'bar' dual 'ba --- bar

see define , defining substitution variables

if want turn behavior off,

sql> set define off

edit: changed set define= set define off per adam musch's suggestion.

oracle10g sqlplus