Re: ORA-00928: missing SELECT keyword

[email protected] Tue, 18 Feb 2003 15:47:26 +0000
Newsgroups gmane.comp.db.oracle.devel
Message-ID <LYRIS-1796914-879014-2003.02.18-15.48.28--gcdod-oracle#[email protected]>
send the insert statement
but youre probably missing the VALUES keyword.



Regards
Chris Farmer



                                                                                                     
                      Tom Skillman                                                                   
                      <tskillman@stlwat        To:       "Oracle" <[email protected]>              
                      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

[email protected]
(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 [email protected].