Link to home
Start Free TrialLog in
Avatar of Wm Allen Smith
Wm Allen Smith

asked on

Sql Developer Oracle12 c--not enough values

Hi
I am getting a "not enough values" error in SQL developer. I am trying to enter  three user-prompted values into a table that contains five fields. Here is the query:

INSERT INTO  APPEALS (APPEAL_ID, CRIME_ID,FILING_DATE, HEARING_DATE, STATUS)
VALUES  '', &CRIME_ID, &FILING_DATE 'MM-DD-YYYY' , &HEARING_DATE 'MM-DD-YYYY','';

Appeal_Id is a sequence value; &CRIME_ID, &FILING_DATE, &HEARING_DATE  are substitution variables.

What am I doing wrong here? Any help would be appreciated.

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Wm Allen Smith
Wm Allen Smith

ASKER

thanks i forgot about that :)