Re: ORA-00928: missing SELECT keyword

Put flasher (date) in CAPS ie.  Flasher("DATE")
Unless you created the column with double quotes and in lowercase
The default case for all column names is UPPERCASE unless created with
double quotes

-----Original Message-----
From: Tom Skillman [mailto:[email protected]] 
Sent: Tuesday, February 18, 2003 11:28 AM
To: Oracle
Subject: [oracle] Re: ORA-00928: missing SELECT keyword

Ok fixed that problem, I have one more though.  Everything works fine,
but if I use my PHP script to insert values into the database, I get the
following error:  

ORA-01009: missing mandatory parameter -- while processing OCI function
OPARSE


I am using the exact same query between SQL Plus and my PHP script, so
I'm suspecting something with the PHP, but if you have any ideas, help
would be greatly appreciated.


					Tom



[email protected] wrote:
> 
> youre going to have to put flasher(date) in double quotes
> like this
> 
>       insert into flasher("date") values ( '12-dec-20')
> 
> Regards
> Chris Farmer
> 
>

---
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].