Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem with update

Re: Problem with update

From: Mike Cretan <nospamthanks_at_nowhere.com>
Date: Sat, 17 May 2003 09:18:14 GMT
Message-ID: <q7nxa.853$7I4.7026@news-server.bigpond.net.au>


Check the data for the line it stops on, I think it may have an '&' in which case sql*plus will stop and prompt for a value because the & indicates a parameter variable.

Try this at the start of your script:

SQL> set scan off

This tells sql*plus to ignore parameter substitution variables.

Mike

"Marc Eggenberger" <marc.eggenberger_at_itc.alstom.com> wrote in message news:MPG.19232a625accf98698968f_at_H02374...
> Hi there ...
>
> I have a few (couple hundrets) lines like this in a textfile:
>
> update ams.hardware set kostenstl = '11016' where kostenstl = '11006';
>
> and as last line I have a
>
> commit;
>
> when I connect to the Oracle 8i Server and do the following in sqlplus:
>
> @{path_to_file}\updt.sql
>
> it hangs ... if I do a
> set echo on
> I see, that it always hangs on the same update statement.
>
> Am I missing something here? Some kind of buffer which is not big
> enough?
>
>
>
> --
> mfg
> Marc Eggenberger
Received on Sat May 17 2003 - 04:18:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US