Skip to Main Content

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!

PL/SQL bind variable insert

NewApexCoderJan 10 2013 — edited Jan 10 2013
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 7 2013
Added on Jan 10 2013
8 comments
431 views