Re: Enter value for trust:

milkyway wrote:
> Hello out there,
>
> When loading a file (i.e. just doing an insert), I get this prompt
> during the process:
>
> Enter value for trust:
> old 1: insert into XXX values ('400-00-1000', ....
> new 1: insert into XXX values ('400-00-1000', ...
>
> *BTW, these rows are not the same - the first 3 values to be inserted
> are the same though.
>
> 1 row created
>
> Why am I getting this prompt?
>
> Any help is appreciated ;-)
>
> TIA
It is obvious you have a text field with the following string embedded:

' & Trust'

or

'Bank&Trust'

or something similar. SQL*Plus is taking the & as an indication the text following is a variable needing replacement. As such, you are asked for input you know you do not need.

As you say these are inserts you could do this:

insert into XXX values ('400-00-1000', ..., '..... Bank '||chr(38)||' Trust ...', .....);

You would then have your & in place, without SQL*Plus thinking it's a variable.

David Fitzjarrell Received on Thu Feb 17 2005 - 15:05:05 CST