logo       
Google Custom Search
    AddThis Social Bookmark Button
-->

Re: ORA-00928: missing SELECT keyword: msg#00057

Subject: Re: ORA-00928: missing SELECT keyword
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



<Prev in Thread] Current Thread [Next in Thread>