RE: MERGE statement not running
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 9 Feb 2004 17:47:22 -0500
Randy,
Errors prefixed by SP2 are sqlplus errors. The client tool's command =
list does not include MERGE as a command. You'll need to upgrade the =
client.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Steiner, Randy [mailto:RASTEIN@xxxxxxxx]
Sent: Monday, February 09, 2004 5:33 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: MERGE statement not running
YES!!
But why would my client be the difference? =20
-----Original Message-----
From: Bricklen Anderson [mailto:BAnderson@xxxxxxxxxxxx]=20
Sent: Monday, February 09, 2004 5:31 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: MERGE statement not running
Steiner, Randy wrote:
> On my 9.2.04 db, I am trying to run a MERGE statement and I get the
> following error:
> SP2-0734: unknown command beginning "merge into..." - rest of line
ignored.
> SP2-0734: unknown command beginning "using ( se..." - rest of line
ignored.
> SP2-0042: unknown command "MINUS" - rest of line ignored.
> =20
> I do not think it is my sql, because I copied an example from asktom =
and
got
> the same error on his merge statement. Is there a script or setting I
> missed?
Possibly your sqlplus client version is less than 9?
(just a guess)
--=20
Bricklen Anderson
PresiNET Systems
http://www.PresiNET.com
Online Demo: https://www.presinet.com/secure/login
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
