-
With the following proc ...
BEGIN
exec_ddl('TRUNCATE TABLE PROJECT_WMS_TEMP;');
INSERT INTO PROJECT_WMS_TEMP
SELECT c.project_code, i.title as PROJECT_NAME , i.item_id
FROM client@wms c, item@wms i
WHERE c.client_id = i.client_id
AND i.product_id IN ('CAGA', 'CAGE', 'CAGI', 'CSGJ')
AND i.sub_project_code IN ('@955', '@933')
AND i.status_id IN (40, 41);
Commit;
END;
I get the following error:
ORA-06550: line 12, column 0:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
;
The symbol ";" was substituted for "end-of-file" to continue.
Might anyone clue me into why this is occurring? line 12 is after the last end.
Thanks
Christian
-
I'm not sure, I don't use exec_ddl, I use dbms_sql or execute immediate, but I suppose
exec_ddl('TRUNCATE TABLE PROJECT_WMS_TEMP;');
cannot have ' ; ' along the string. It should be:
exec_ddl('TRUNCATE TABLE PROJECT_WMS_TEMP');
at least in dbms_sql you mustn't use ' ; ' along the string.
F.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|