Run Test- Error

SQL Optimizer SQL Optimizer for Oracle
1

I installed Toad DBA suite for oracle, when trying to optimize any sql statement, I got on the below error when run test for original & alternatives sql statements but from toad we can run all sql statements without any error:

Error

ORA-06550: line 19, column 15:

PLS-00103: Encountered the symbol “=” when expecting one of the following:

. ( , % ; limit

ORA-06550: line 21, column 7:

PLS-00103: Encountered the symbol “FETCH” when expecting one of the following:

constant exception

table long double ref

char time timestamp interval date binary national cha

How can i solve this issue?

Thanks

2

Are you running the query as part of a PL/SQL object? If so you will need to run just the SQL portion of the query in the optimizer.

3

Thanks for your reply

When I used simple sql statement

select * from dual

appear the same error with any simple SQL statement

Note: I am using direct connection

Thanks

From: Mark Kurtz [mailto:bounce-Mark_Kurtz@toadworld.com]

Sent: None

To: sqloptoracle@toadworld.com

Subject: RE: [SQL Optimizer for Oracle - Discussion Forum] Run Test- Error

RE: Run Test- Error

Reply by Mark Kurtz

Are you running the query as part of a PL/SQL object? If so you will need to run just the SQL portion of the query in the optimizer.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from SQL Optimizer for Oracle - General notifications altogether.

SQL Optimizer for Oracle - Discussion Forum

Flag this post as spam/abuse.

4

How are you sending the query to the optimizer? Or from within the Toad editor window or some other means?

5

Please specify where the problem occurs. Are you using the “Auto Optimize SQL” or “Advanced SQL Optimization” features in Toad, or are you running the SQL within Dell SQL Optimizer for Oracle directly?

It would help identifying the cause of the problem by running a SQL Tracker while repeating the problem to see what SQL are running. Please contact Support once you have the SQL Tracker log and we can follow up from there.

Thanks,

Alex

6

I am running the SQL within Dell SQL Optimizer for Oracle directly

7

Thank you for clarifying. Please do a SQL Tracker log and contact Support to open a case for you. Also let Support know the exact version of SQL Optimizer you are using.

Thanks,

Alex