Getting error below when using "Test Performance" option in Toad for Oracle.
Agent(EU6203) Error: Unable to execute statement in ExecuteSQL(). ORA-06550: line 1, column 212:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
begin function pragma procedure subtype type
current cursor delete
exists prior.."
The steps to reproduce the problem are:
Open toad, select a procedure/function/package from the Schema Browser , r-click and select " test performance".
This is a problem when sending SQL to Benchmark Factory (BMF) from Toad to Test.
the SQL statement being received BMF , which includes comment lines, does not contain any CR/LF, so when BMF tries to execute the SQL it appears that everything past the first comment is part of the first comment so it is an invalid SQL statement.
WORKAROUND
Please remove any comments in the code that is sent to BMF.
This code is the one that appears in a Windows right after r-clicking and selecting "Test Performance".
STATUS
This issue is fixed in Toad for Oracle 12.11. This version can be downloaded from the downloads section of our website, which you can access by clicking here.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center