Get Ora-06550 running drop temp table statement in automation (4248746)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Get Ora-06550 running drop temp table statement in automation
Description

At the beginning of a query that involves creating temp tables, a script is added to drop the temp table if it already exists:

BEGIN EXECUTE IMMEDIATE 'DROP TABLE SCHEMA1.TMP_TABLENAME';
EXCEPTION WHEN OTHERS THEN NULL; END;

There are no issues if running this query alone in Toad 4.2, but as an automation Tas file, it runs into an error:

ORA-06550: line 2, column 36:
PLS-00103: Encountered the symbol "end-of-file"
Cause

Toad is adding an additional “;” to the script which then causes the error.
Resolution

WORKAROUND:
None

STATUS:
This issue is fixed in Toad Data Point 4.3. This version can be downloaded from the downloads section of our website, which you can access by clicking here.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title