PL/SQL bind variable insert
I am trying to insert a few values into a table in pl/sql. One is a bind variable and I cannot pin point the error. I keep getting the error PLS-00103 - encounters the symbol "end-of-file" when exepcting one of the following.....
Here's my query
DECLARE
v_task_id number;
v_sequence number;
BEGIN
SELECT TASK_ID,
SEQUENCE
INTO V_TASK_ID,
V_SEQUENCE
FROM SCHEDULE_TASK_XREF
WHERE TASK_ID = 1;
INSERT INTO SURVEY_JOB_TASKS (SURVEY_JOB_TASK_ID, SEQUENCE, PLANNED_START_DATE, ACTUAL_START_DATE, PLANNED_END_DATE, ACTUAL_END_DATE, TASK_ID, SURVEY_JOB_BUNDLE_ID) VALUES
('', 'V_SEQUENCE', '','','','', 'V_TASK_ID', ':P24_SURVEY_JOB_BUNDLE_ID')
END;
Any help would be greatly appreciated. Thanks in advance