With the following proc ...
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);
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.
Click Here to Expand Forum to Full Width