PLS-00103: Encountered the symbol "end-of-file" .....

[psiclonik]

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

[Mnemonical]

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.