ACCEPT command wont work

Hello, 

ACCEPT p_name PROMPT 'Please enter the Patient Name :' 
ACCEPT p_address PROMPT 'Please enter the address :' 
ACCEPT p_sex PROMPT 'Please enter the Sex :' 
ACCEPT p_age PROMPT 'Please enter the age :' 
ACCEPT p_contact PROMPT 'Please enter the contact no:' 
ACCEPT p_first_vis PROMPT 'Please enter the First Visit Date :' 
ACCEPT p_last_vis PROMPT 'Please enter the Last Visit Date :' 
INSERT INTO patient
(no,name,address,sex,age,contact_no,first_visit,last_visit) 
VALUES (patient_no.NEXTVAL,UPPER
('&name'),'&p_address','&p_sex',&age,&contact,TO_DATE
('&first_vis'),TO_DATE('&last_vis')) 
/ 

I am getting : 

ACCEPT p_name PROMPT 'Please enter the Patient Name :' 
* 
ERROR at line 1: 
ORA-00900: invalid SQL statement 

After I run the run and enter the value for the prompt . 


Please advise. 


Thanks 

---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].