PL/SQL warning not displaying in SQL window

[Apotheosis]

Hi,

I have tried all the solutions on the internet but haven't been able to solve this problem.

I have tried ALTER SESSION SET PLSQL_WARNINGS='ENABLE:ALL';

Can anyone guide me how to solve this?

There was a thread here but that thread was not for Sql window.

 

[Marco Kalter]

To display compilation errors and warnings you need to use the Program Window. The SQL Window will not display them.

 

[Apotheosis]

I am sorry for the misunderstanding.

But previously, whenever I encountered an error in SQL window, the cursor would point to the location where the query failed. That way it was easier to solve the problem.

Right now, the cursor doesn't show me the line number or the location hence I am unable to determine the location of the error.

Is this called PL/SQL warning or is there other term for this?

How do I fix this?

 

[Marco Kalter]

Can you provide an example of a SQL or PL/SQL command that fails and for which there is no error location highlighted?