Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00917: missing comma

767331Apr 16 2010 — edited Apr 19 2010
i'm trying to insert some values in my table but i'm getting this error:
ORA-00917: missing comma

i'm using php and the query is like this:

$insertar=oci_parse($conexion,'insert into medicos (fecha-presc,ciudad_presc,nombre) Values ("17-04-2010","mexico","Fulanito Mayor")');
oci_execute($insertar);

what coul be wrong??

i created a sequence and a trigger for making the id_medico field auto-increment...


thanks !!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 17 2010
Added on Apr 16 2010
12 comments
14,678 views