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

Tchater maintenant avec le support

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

Retour

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Titre

Error "ORA-00936: Missing Expression" when clicking on 'System' tab of Session Browser | Locks
Description
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
Cause

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.
Résolution

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.
Identifiant du défaut

TOR-1219

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Contenu recommandé

Historique de l’article :: Créé le : 10/5/2016
Dernière mise à jour le : 5/7/2023

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