send the insert statement
but youre probably missing the VALUES keyword.
Regards
Chris Farmer
Tom Skillman
<tskillman@stlwat To: "Oracle"
<oracle@xxxxxxxxxxxx>
er.com> cc:
Subject: [oracle] ORA-00928:
missing SELECT keyword
18/02/2003 15:43
Please respond to
"Oracle"
I have come up to a strange problem which I can't figure out. I have a
table which holds details of rental barricades. I have set most of the
fields to accept NULL values for testing. The only required field at
this point is the Date. When I try to insert a record (using SQL Plus,
my PHP code, or the DBA Studio), I get an error ORA-00928: missing
SELECT keyword. I can't figure out why it's wanting a select statement
when I'm doing an INSERT. I've searched the web briefly, but can't find
any info. Thanks in advance for your help.
==============================
Tom Skillman
Programmer/Analyst I
City of St. Louis Water Division
tskillman@xxxxxxxxxxxx
(314) 771-4806 ext 184
---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to %%email.unsub%%.
---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to leave-oracle-1796914O@xxxxxxxxxxxxx
|