Skip to Main Content
Forums

APEX

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-00936: missing expression

788558Aug 23 2010 — edited Aug 24 2010
i am getting a ORA-00936: missing expression error when trying to create a submit button. the sql expression i am trying to put in is 
INSERT INTO TIME_TRANS(PROJ_NUM, USER_NAME, TIME_WORKED, UPDATED)
VALUES(P17_PROJ_NUM, P17_USER, P17_TIME_WORKED, P17_UPDATE)
The P17_* are my field names. I am trying to insert the values from those fields to the columns in TIME_TRANS.
any ideas?

Edited by: KySarge1981 on Aug 23, 2010 12:20 PM - a lil more clarification...
This post has been answered by Sam.K on Aug 23 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 21 2010
Added on Aug 23 2010
#apex, #apex-discussions, #oracle, #sql
6 comments
1,237 views