Home » SQL & PL/SQL » SQL & PL/SQL » Incomprehensible sqlplus error
Incomprehensible sqlplus error [message #298] Mon, 04 February 2002 05:26 Go to next message
Ebe
Messages: 2
Registered: February 2002
Junior Member
I am trying to delete a record from one of the tables. In sqlplus I issue the following command and get the following error:

SQL> del from idps where employee_id='BENXXX';
SP2-0224: invalid starting line number

There isnt much explanation about this error in the Oracle help files. Cant make any heads or tails out of it myself either. I tried it with another employee and still get the same error. Will appreciate very much if you can crack this mystery.
Re: Incomprehensible sqlplus error [message #299 is a reply to message #298] Mon, 04 February 2002 05:32 Go to previous messageGo to next message
Mike
Messages: 417
Registered: September 1998
Senior Member
DEL is not a sql command. Use DELETE instead.

HTH
Mike
Re: Incomprehensible sqlplus error - Tx It Worked!! [message #305 is a reply to message #298] Mon, 04 February 2002 09:55 Go to previous message
Ebe
Messages: 2
Registered: February 2002
Junior Member
Tx, It worked!!
Previous Topic: I need help... could you help me?
Next Topic: Error 0RA01031
Goto Forum:
  


Current Time: Thu Mar 28 09:45:36 CDT 2024