SP2-0003 Ill for timestamp. Please help
timestamp is not a valid type when using ACCEPT. Use date.

SQL*Plus® User's Guide and Reference - ACCEPT

SQL&gt; !cat 1.sql
ACCEPT v_cheindatetime date FORMAT 'DD-MON-YY HH:MI:SS' PROMPT 'Enter Checkin Date and Time : '
ACCEPT v_cheoutdatetime date FORMAT 'DD-MON-YY HH:MI:SS' PROMPT 'Enter Checkout Date and Time : '

--execute the INSERT statement
INSERT INTO booking VALUES
('&amp;v_cheindatetime','&amp;v_cheoutdatetime');

SQL&gt; @1
Enter Checkin Date and Time : 06-AUG-16 12:00:00
Enter Checkout Date and Time : 07-AUG-16 12:00:00
old   2: ('&amp;v_cheindatetime','&amp;v_cheoutdatetime')
new   2: ('06-AUG-16 12:00:00','07-AUG-16 12:00:00')

1 row created.