Error "ORA-00936: Missing Expression" when clicking on 'System' tab of Session Browser

Chatee ahora con Soporte

Error "ORA-00936: Missing Expression" when clicking on 'System' tab of Session Browser | Locks (4308824)

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

Error "ORA-00936: Missing Expression" when clicking on 'System' tab of Session Browser | Locks
Descripción
Error "ORA-00936: Missing Expression" when clicking on 'System' tab of Session Browser | Locks.
1. Open Session Browser
2. Don't select a session
3. Click on lower right hand side LOCKS tab
4. click locks tab between User and System
Causa

This tab requires a session (or sessions, or a node with sessions under it) to be selected on the left/top. The error is occurring because the underlying query expects a value for SID, and since no session has been selected, the missing expression error is displayed.
Resolución

WORKAROUND
If interested in locks database wide, not restricted to a list of sessions, then click the locks tab up at the top of the Session Browser (next to the Sessions tab). Otherwise, select a particular session.
STATUS
Issue fixed in version 12.11 (User will be presented with an informational message, that a session needs to be selected)
The latest release of Toad for Oracle can be downloaded here.
ID de defecto

TOR-1219

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Contenido recomendado

Historial del artículo:: Creado el: 10/5/2016
Última actualización: 5/7/2023

Error "ORA-00936: Missing Expression" when clicking on 'System' tab of Session Browser | Locks (4308824)