Home » RDBMS Server » Server Administration » data load warnings.
data load warnings. [message #228844] Wed, 04 April 2007 06:53 Go to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
SP2-0734: unknown command beginning "Insert ..." - rest of line ignored.
(ENAME, EMPID, LOCATION, DEPTNO)
*
ERROR at line 1:
ORA-00928: missing SELECT keyword


I have stored as insert statements in toad, i just executed from sql*plus like
sql>@script_test

But is shows those above line, anyhow all the rows got inserted...
could you please tell me why this happened?

Thanks,
Shahnaz.
Re: data load warnings. [message #228846 is a reply to message #228844] Wed, 04 April 2007 06:55 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>could you please tell me why this happened?
Not unless you could post the contents of that mysterious script Smile
Previous Topic: Finding sessions
Next Topic: Oracle Block Structure
Goto Forum:
  


Current Time: Fri Sep 20 01:49:28 CDT 2024